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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy