I created a custom WMI sensor to measure Network IO Wait for SQL Server. Here is the query:

SELECT NetworkIOWaits FROM Win32_PerfFormattedData_MSSQLMSSQLSERVER2008_MSSQLMSSQLSERVER2008WaitStatistics WHERE name='average wait time (ms)'

However, it won't display any data over 2000 ms. The graphs have a flat top. How can I get this to show the real data. I got the same result using RAW data.

Thanks

Article Comments

Dear Dean,

which result do you get running the query with our WMI Tester from the PRTG Host?

best regards.


Sep, 2011 - Permalink

I am getting 80041008 error with your tool, but when I use WMI Explorer it also maxes out at 2000


Sep, 2011 - Permalink

PerfMon maxes out at 2000 also. Hmm....something about the counter itself then


Sep, 2011 - Permalink

Indeed, that seems to be an issue on the counter, not PRTG.


Sep, 2011 - Permalink