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 ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.