The OS Average Disk Queue Length (Count) alert provides the average number of both read and write requests queued for all the disks on the SQL Server computer.

Reduce queue length

If this queue often remains above six per physical disk for more than 10 seconds at a time, then your disk subsystem is overloaded. In this case consider the following:

To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window.

Create an alert response bundle with the OS Average Disk Queue Length (Count) alert and related alerts.  For additional information, see Create alert response bundles

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal