Determine total no of logical/physical reads

Question

I am working on the optimization of a SP which contains some business logic using looping. I have removed the looping and converted those piece of code into some simple insert/update statements.

Now I've to do benchmarking and compare old and new code in terms of execution time and logical/physical reads.

My problem is because of the loop in my old code, how can I determine what is the total no of logical/physical reads. Because in SSMS, I can see thousands of IO stats statements like:

"Table 'Employee'. Scan count 1, logical reads 3, physical reads 0, read-ahead reads 0, lob logical reads 43, lob physical reads 0, lob read-ahead reads 0."

Answer 1

I can think of 3 options to get the total reads:

1. Extended Event session
2. SQL Profiler
3. IO Statistics Parser

IO Statistics Parser is pretty simple, just copy/paste your STATISTICS IO output and voila!

Answer 2

The best tool that I have found for query tuning is Plan Explorer.

You can get full execution plan along with Table IO - LOB Logical Reads, Physical Reads, Scan Count, etc.

In Pro version, you can even track the optimizations (history) that you have made by comparing the previous and optimized versions.