Nagios Support Forum

Code: Select all

./check_mssql_server.py -H myIP -U myuser -P mypass --locks-deadlocks --warning 20 --critical 30

Code: Select all

define service{            
    use            service-sql-server              ; See Service Templates section below
    host_name        XXXXXX        
    service_description    SQL DEAD LOCKS
    check_command        check_sql_deadlocks!"domain\user"!password!locks-deadlocks
    }

Code: Select all

# 'check_mssql_health Deadlocks' command definition
define command{
    command_name    check_sql_deadlocks
    command_line    $USER1$/check_mssql_health -server $HOSTADDRESS$ -username $ARG1$ -password $ARG2$ -mode $ARG3$
    }

Code: Select all

Command line parameters

    –hostname <hostname> The database server

    –username <username> The database user

    –password <password> The database passwort

    –port <port> The port, where the server listens (Default: 1433)

    –server <server> An alternative to hostname+port. <server> will be looked up in the file freetds.conf.

    –mode <modus> With the mode-parameter you tell the plugin what you want it to do. See list below for possible values.

    –name <objectname> Several checks can be limited to a single object (e.g. a specific database). It is also used for mode=sql. (See the examples)

    –name2 <string> If you use –mode=sql, the SQL-statement will be shown in the plugin output and the performance data (which looks ugly). The parameter name2 can be used to provide a used-defined string.

    –warning <range> Values outside this range result in a WARNING.

    –critical <range> Values outside this range result in a CRITICAL.

    –environment <variable>=<wert> It is possible to set environment variables at runtime with htis parameter. It can be used multiple times.

    –method <connectmethode> With this parameter you tell the plugin, which connection method it should use. Known values are: dbi for the perl module DBD::Sybase (default) and sqlrelay for the SQLRelay proxy..

    –units <%|KB|MB|GB> This parameter adds units to the performance, when using mode=sql

    –dbthresholds With this parameter thresholds are read from the database table check_mssql_health_thresholds