Curious if anyone has run into this situation. For the Disk Queue Length custom or manually created monitor I am getting back response time but no statistical data. I have created memory, pagefile, etc monitors to verify the wmi functions and they worked. However it seems when multiple instances are available, ie 4 disks it isn't reporting back any stats.
I have tried the items below against multiple nodes. The G item was for a SQL server with a G drive as a test. The disk queue length on one of the test servers is constantly averages between 4 and 6, 16 spindles running a large SQL instance.
SELECT AvgDiskQueueLength FROM Win32_PerfFormattedData_PerfDisk_PhysicalDisk WHERE Name="_Total"
SELECT AvgDiskQueueLength FROM Win32_PerfFormattedData_PerfDisk_PhysicalDisk WHERE Name="3 G:"
I have even tried single ' instead of " for the where values.
NPM 9.0 SP2
APM 2.0
OS: Win2K3 R2 x64 SP2