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 disk I/O statistics

As a DBA, you often have to face disk I/O-related problems with your databases that might have been introduced due to a number of reasons, and you have to analyze and troubleshoot I/O performance of your databases. SQL Server provides certain DMVs and DMFs that can be specifically used for troubleshooting such I/O-related performance issues.

This recipe will teach you how you can monitor your disk I/O subsystem for your databases to identify any possible I/O bottlenecks. By monitoring how your databases consume disk subsystem, you can distinguish the I/O usage patterns across different databases and can make your decisions related to physical structure of the databases. You can identify those databases that are causing ...

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