Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

...

Tip
titleCreate an alert response bundle

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



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
| 

...

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

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...