O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required