Check MSSQL Database Stats

This plugin is geared explicitly for gathering information on specific databases rather than the database as a whole.

I also added a doc on the exchange, please refer to it if you're connecting to instances on an MSSQL database. It says Nagios XI on it but will still apply to Nagios Core as well:

https://assets.nagios.com/downloads/nagiosxi/docs/Nagios_XI_Installing_MSSQL_Wizard_Prereqs.pdf

Installation of the plugin is easy and involves a call to the python plugin pymssql which is included with most packaging software. For Ubuntu:

sudo apt-get install python-pymssql

For Red Hat based:

yum install pymssql # Some repos have it python-pymssql

Then it should run no problem. I am *VERY* open to feature additions and bugs, so please bring them to my attention if you find them/have a need for them.

Examples of use are:

./check_mssql_database.py -H 192.168.0.1 -U user -p password --transpsec -w 20 -c 30

Now keep in mind if you're going to using percentages the w and c get a little trickier. This plugin is Nagios Plugin compliant as far as the bounding goes, fully supporting the use of the : ~ and @ symbols. Here is an example of what you'd do for the warns and crits on Log Cache Hit Ratio:

./check_mssql_database.py -H 192.168.0.1 -U user -p password --logcachehit -w 95: -c 90:

This will return warning of the percentage goes below 95% and critical if it goes below 90%.

For information the the use of ~ : and @, refer to section 2.5 of the Nagios Plugin Guidline here: http://nagiosplug.sourceforge.net/developer-guidelines.html

Metrics that it currently covers:

--datasize Check size of database
--logfileusage Check Log File Usage
--activetrans Check Active Transactions
--transpsec Check Transactions/Sec
--logcachehit Check Log Cache Hit Ratio
--time2connect Check Time to Connect [DEFAULT]
--loggrowths Check Log Growths
--logshrinks Check Log Shrinks
--logtruncs Check Log Truncations
--logwait Check Log Flush Wait Times
--logflushes Check Log Flushes/Sec

These are for specific databases on a MSSQL, if you want to see these metrics applied on your entire database, you can specify the database _Total, but again, this plugin is geared towards checking specific databases.

Be sure to take advantage of using Python by compiling this plugin to a pyc if you're running lots of checks with it!

Changelog:

1.1 - Fixed port bug that only allowed default port. Thanks for the tip CBTSDon!
Fixed ungraceful exit if mode not specified | Thanks mike from austria
1.3 - Added ability specify instances.