Monitoring performance of a query by SET STATISTICS IO

Note

There are so many weapons in the world, but it depends on the person what to choose. Everybody has their own choice which may or may not change with the situation. Some people like to use Stilettos whereas some would like to go for Swords. Some people love Nunchucks whereas some would like to use Spartan Spearhead.

Microsoft has also provided many weapons in SQL Server 2012 to monitor and deal with performance issue; you can choose your weapon and use it. SET STATISTICS IO is one of the light weight weapon that can be used very easily to get some of the important information regarding input and output resources consumed by the batch we have executed.

SET STATISTICS IO is an evergreen weapon and most DBA never forget to give it a shot as the first step on the enemy (slow performance). SQL Server used to provide this weapon from the initial versions of SQL Server and it is still available in SQL Server 2012 without change. This is really...