Monitoring SQL Server disk I/O with PerfMon countersDate: Apr 01, 2008
As a DBA, you need to understand the I/O of your SQL Server disk subsystem. In part three of this screencast series, SQL Server MVP Kevin Kline explains how to track I/O in your direct-attached storage disks (DASD).
Get optimal throughput values to keep an eye on when using Performance Monitor counters for physical disk reads and writes and disk queue length. Kline also shares some best practices you can't afford to miss.