Statistics IO for Performance Tuning in SSMS
Statistics IO and Statistics Time is another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks.
Have you ever wanted to know exactly how long it took for a query to run? Have you ever wondered how many I/O reads or writes were caused by your query? With Statistics IO and Statistics Time you can understand both of these.
Statistics IO for Performance Analysis
This post is on using statistics IO to analyze query performance. There is another post on using Statistics Time for performance tuning.
I usually prefer to use Statistics IO over Statistics Time because the Statistics IO option gives better details on what exactly the query is doing.
Let’s take the following query as an example: