Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Size of Query result set Expand / Collapse
Author
Message
Posted Tuesday, January 7, 2014 7:29 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:26 AM
Points: 78, Visits: 252
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 ?
Post #1528483
Posted Tuesday, January 7, 2014 3:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 6:43 PM
Points: 57, Visits: 97
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/
Post #1528706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse