Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

check_mssql_server.py "Average Wait Time" #18

Open
hatebur opened this issue Apr 18, 2018 · 0 comments
Open

check_mssql_server.py "Average Wait Time" #18

hatebur opened this issue Apr 18, 2018 · 0 comments

Comments

@hatebur
Copy link

hatebur commented Apr 18, 2018

According to Microsofts counter type definition (see https://blogs.msdn.microsoft.com/psssql/2013/09/23/interpreting-the-counter-values-from-sys-dm_os_performance_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 current compared to expected:
file

Is there a chance that you could update the plugin so this metric is calculated more accurate?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant