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
Add comment