Monitoring SQL Server disk I/O with PerfMon counters

Monitoring SQL Server disk I/O with PerfMon counters

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

More on Microsoft SQL Server Performance Monitoring and Tuning

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: