The Disk Queue Length metric counts the average number of system requests that are waiting for disk access on the computer hosting the SQL Server instance. The Disk view on the Resources tab allows you to track your Disk Queue Length, along with other key disk statistics, over a period of time on the computer hosting your SQL Server instance.
Reasons why this metric has no value
SQL Diagnostic Manager is unable to collect the corresponding counter due to one of the following reasons:
- It usually takes two refreshes to begin populating the Disk Queue metric, which occurs within a few seconds.
- OS Metrics collection is disabled or not working properly. You must enable OS Metrics collection for SQLdm to collect hardware performance metrics.
- Lightweight Pooling is enabled. SQL Diagnostic Manager cannot collect OS metrics if Lightweight Pooling is enabled on the SQL Server instance.
- The counter does not exist on this SQL Server instance.