Capturing Bytes per Query

• plaid_draco

  Mr or Mrs. 500

  Points: 523

  More actions

  January 28, 2010 at 12:31 pm

  #216046

  I have a myriad of different queries on different tables that I captured in a profiler trace. If I re-execute any or all of the queries the trace captured is there an easy way to determine how many bytes any or all of the queries returned?

  I would determine this manually but I have about 50k rows of trace data I need to sift through, and there are dozens of tables all with varying definitions. Thus, I'd like to automate this and am looking for a quick and dirty solution. If something quick doesn't exist I'm not above writing a bunch of dynamic code.

  Thanx much for any ideas...

• Paul White

  SSC Guru

  Points: 150457

  More actions

  January 31, 2010 at 4:47 am

  #1111309

  No, not as far as I know. Seems an odd requirement though.

  Take a look at the data available from the sys.dm_exec_sessions and sys.dm_exec_connections DMVs.

  You can get packet counts, reads, writes, row counts and more from there.

  Might help.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi