Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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



Group: General Forum Members
Last Login: Monday, August 29, 2016 7:02 AM
Points: 132, Visits: 470
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.
Post #1528706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse