February 26, 2013 at 4:16 am
Hello in a testing scenario, I want to have access to the physical reads for every individual query.
With statistics io on, I get the physical reads in text format.
Is it possible to get these number in a table format, or query for these numbers ?
Thanks,
Ben Brugman
February 26, 2013 at 8:27 am
Greg Larsen has an excellent article about query metrics here:
http://www.sql-server-performance.com/2008/Query-Execution-Statistics/
March 1, 2013 at 9:18 am
Erin Ramsay (2/26/2013)
Greg Larsen has an excellent article about query metrics here:http://www.sql-server-performance.com/2008/Query-Execution-Statistics/
Thanks for the link.
Allthough with the profiler you can get results for individual statements, the profiler does not make a distinction between logical an physical diskacces. (And the numbers are not consistent with statistics IO)
And with statistics IO you get very clear readable data, but this is more for a human readable form, to convert this into table information is rather cumbersome.
thanks,
ben brugman
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply