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 or demanding high number of I/O operations. Then, you may either want to move the databases having justified high number of I/O operations on separate disks, or you may want to investigate databases further for high number of I/O operations.
