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 ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
