January 28, 2010 at 12:31 pm
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...
January 31, 2010 at 4:47 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply