Page 1 of 1
How check_mssql_health calculate?
Posted: Tue Apr 09, 2013 12:45 pm
by xpertech
How check_mssql_health calculate?
From the attachment graph, the check_mssql_health show 43.01% free space left, I can't figure out how it calculated?
Re: How check_mssql_health calculate?
Posted: Tue Apr 09, 2013 1:10 pm
by abrist
Is your database set up for a maximum size? This is weird though.
Re: How check_mssql_health calculate?
Posted: Tue Apr 09, 2013 1:30 pm
by slansing
It looks like this has been reported before from the consollabs.de page of this plugin:
http://labs.consol.de/nagios/check_mssql_health/
I would ask the developer about this as it seems he answers questions regarding this via email, and does not post the solution. We can try to help from our end but it is unlikely we will be as effective as the developer is.
Re: How check_mssql_health calculate?
Posted: Tue Apr 09, 2013 9:06 pm
by xpertech
That DB allocate space was fixed.
What the user want is to monitor the available free space of that DB(fixed space allocated and should not include disk available free space), so I think check_mssql_health is not suitable for this case because it calculate total disk available free space.
Is there recommend wizard or scripts for this situation?
Re: How check_mssql_health calculate?
Posted: Wed Apr 10, 2013 12:33 pm
by slansing
You could grab the Perf Counters out of windows and use the windows server monitoring wizard, and add them in the Performance Counters section. Otherwise we do have a few MSSQL wizards available from within XI.
Re: How check_mssql_health calculate?
Posted: Wed Apr 10, 2013 12:52 pm
by abrist
There are also a good number of mssql plugins on the exchange. A few are specifically tablespace size checkers. Take a look:
http://exchange.nagios.org/index.php?op ... word=mssql