Size of Query result set

  • Hi,

    I am in process to compute query result set size to compute its impact on network.

    I am using client statistics "Bytes received from server" in SSMS.

    Is there other way with TSQL ?

  • Assuming it's the network impact you care about, that's precisely the metric that matters. Your network does not care how hard SQL Server had to work to create the query, only how much data it had to pass through. The only other question I can think of is, how much data do you SEND, for example, if your database is supporting an internal web application of some sort, then is the SQL Server and IIS on the same machine and, if not, how are requests sent to the DB, and if, for example, you need to insert 10 rows, do you send one request to the DB, or 10 ? You can track the number of transactions made in a time span ( but of course, not all transactions are the same size ), but in general, just tracking the network traffic seems like the right port of call to me. Just remember to track it in both directions to get a real picture.

    http://blog.sqlauthority.com/2010/10/04/sql-server-find-total-number-of-transaction-on-interval/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply