check_mssql_nt

Project Notes

MS SQL Server Nagios Check Plugin v0.1

This program is free software; you can redistribute it and/or modify it under the GNU General Public License.
Written by Francois Zbinden (zbinden at dataflow dot ch), 2008

This program is a Win32 native Microsoft SQL Server Nagios check plugin for use with NRPE_NT. It requires SQL Server Native Client installed. You can use it to just detect SQL Server connectivity or run querys. Performance data output is supported.

Usage: check_mssql_nt.exe [/h] /H:hostname [/D:dbname] [/U:username] [/P:password] [/t:timeout] [/CHK_CONNECT] [/CHK_CONNECTIONCOUNT] [/CHK_QUERY:ownquery] /w:warn_secs /c:crit_secs /Wv:[max_value|min_value:max_value] /Cv:[max_value|min_value:max_value] [/PF:outformatter]

/h, /?
Display the help

/H:
Hostname of the sql server

/D:
Database name

/U:
Username. If empty it will try to login using the current windows account.

/P:
Password

/CHK_CONNECT
Try to connect the database. This is the default

/CHK_CONNECTIONCOUNT
Actual count of connections. If a database name is specified, count of connections to the database.

/CHK_QUERY:
SQL Query to execute. The query must return one record, if no record or mutliple record are returned, it will produce a CRITICAL. If one record is returned, the value will be the first row of the record.

/w:
Warn if query duration is longer than value

/c:
Critical if query duration is longer than value

/Wv:
Warn if query result value is bigger than value

/Cv:
Critical if query result value is bigger than value

/FO:
Pretty format the output. Use %d as value placeholder. Example: /FO:"%d pending orders"

/t:
Timeout in seconds

Examples:
Check connectivity:
check_mssql_nt /H:sqlv1

Check connectivity with time check (warn>= 0.1s, critical>= 2s):
check_mssql_nt /H:sqlv1 -w:0.1 -c:2

Check total connections count of all databases (warn if count>= 50, critical>= 100):
check_mssql_nt /H:sqlv1 /CHK_CONNECTIONCOUNT -Wv:50 -Cv100

Check total connections count of 'warehouse' databas (warn if count is over 50, critical over 100):
check_mssql_nt /H:sqlv1 /D:warehouse /CHK_CONNECTIONCOUNT -Wv:50 -Cv100

Check a custom query (warn if result is over 50 or query duration is over one second, critical over 100 or duration is over 5 seconds):
check_mssql_nt /H:sqlv1 /D:warehouse /CHK_QUERY:"select count(*) from orders where status='pending'" -W1 -C5 -Wv:100 -Cv100 /FO:"%d pending orders"

You can also use it as a event handler:
check_mssql_nt /H:sqlv1 /CHK_QUERY:"delete from orders where status='error'"