check_mssql_server.py "Average Wait Time"
Posted: Tue Apr 17, 2018 8:24 am
According to Microsofts counter type definition (see https://blogs.msdn.microsoft.com/psssql ... _counters/) the "Average Wait Time (ms)" counter is of type PERF_AVERAGE_BULK, and should be measured from two samples.
Currently, as far as i understand, the "Average Wait Time" in the Script check_mssql_server.py, Version 2.1.0, 06/24/2016, is calculated from only one sample of counter "Average Wait Time (ms)" directly divided by counter "Average Wait Time Base". See attached picture. Is there a chance that you could update the plugin so this metric is calculated more accurate?
Currently, as far as i understand, the "Average Wait Time" in the Script check_mssql_server.py, Version 2.1.0, 06/24/2016, is calculated from only one sample of counter "Average Wait Time (ms)" directly divided by counter "Average Wait Time Base". See attached picture. Is there a chance that you could update the plugin so this metric is calculated more accurate?