Page 1 of 1
check_xi_mssql_server returning innacurate values
Posted: Mon Jun 25, 2012 5:46 pm
by codell
And I mean *wildy* inaccurate values... like 32996357.0ms for Average Wait. Some metrics are measured correctly, like Lock Waits / Sec and Connection Time. See the attached .png for the MSSQL service details & results.
Running Nagios XI 64 .vhd on Hyper-V, Centos 6.2. I believe I have all the pre-reqs for the mssql plugin installed. The server I'm trying to monitor is MSSQL 2005 Sp3, running on Server 2003.
Any help much appreciated!
Capture.PNG
Re: check_xi_mssql_server returning innacurate values
Posted: Wed Jun 27, 2012 10:34 am
by nscott
I'm going to change how this plugin is implemented. Currently its implemented in a way that would allow for bogus numbers like this to happen as it bases most 'per second' metrics off of how long tempdb has been alive. I'm working on reimplementing it right now and hope to have something later today for it. I would appreciate it if you wouldn't mind testing out the changes.
Re: check_xi_mssql_server returning innacurate values
Posted: Wed Jun 27, 2012 12:21 pm
by codell
Sure, I'd be happy to test an update for you.
Re: check_xi_mssql_server returning innacurate values
Posted: Mon Nov 05, 2012 5:28 am
by Nitpat
Hello guys,
Any update on this issue. We are also facing the same issue.
Thanks,
Nitin P
Re: check_xi_mssql_server returning innacurate values
Posted: Mon Nov 05, 2012 6:28 am
by JulianFDRacing
I am suffering the same issue too but thought it was a MS issue with the counters value being 93x what it should be, I could be wrong as this info was passed on to me but could explain why development seems so slow on this