Collect the data for PhysicalDisk:% Idle Time

May 6, 2010 at 8:49 PM

Hi,

The SQLH2 we have installed does not seems to be collecting the data for "PhysicalDisk:% Idle Time" counter (On 32-Bit, Windows 2003 Server).

The SQLH2 version I am using is from Microsoft. I have not tried the version posted here. Can anyone confirm that the latest version here can track the counter listed above?

Thanks,

Bhavi Patel

Coordinator
May 11, 2010 at 1:01 AM

SQLH2 doesn't differentiate counters. It collects all counters the same way. If it collects other counters ok, but this one has troubles, the problem is most likely with the counter, not the collector.

Check Application Event Log for any messages from collector. If it cannot collect a counter it will write an error message into the log. It will attempt a few retries also.

You can also check if you can get the counter using perfmon. If you can make sure you use the right counter name in the config file (every character is meaningful, including spaces).