Do you need more than STATISTICS IO for Query Tuning?
The session option STATISTICS IO is my friend during query tuning engagements, because it tells you exactly how many page reads you had for a specific query. Every time that SQL Server requests a page of 8KB from the Buffer Pool, it gets logged through the output of STATISTICS IO. As a general guide I …
Do you need more than STATISTICS IO for Query Tuning? + read more
