How check_mssql_health calculate?

[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?

[abrist]

Is your database set up for a maximum size? This is weird though.

[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.

[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?

[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.

[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