check_mssql_health ^Popular

$ check_mssql_health --help


Copyright (c) 2009 Gerhard Lausser








  Check various parameters of MSSQL databases 





  Usage:


    check_mssql_health [-v] [-t ] --hostname=


        --username= --password= [--port ]


        --mode=


    check_mssql_health [-v] [-t ] --server=


        --username= --password=


        --mode=


    check_mssql_health [-h | --help]


    check_mssql_health [-V | --version]





  Options:


    --hostname


       the database server


    --port


       the database server's port


    --server


       the name of a predefined connection


    --currentdb


       the name of a database which is used as the current database


       for the connection. (don't use this parameter unless you


       know what you're doing)


    --username


       the mssql user


    --password


       the mssql user's password


    --warning


       the warning range


    --critical


       the critical range


    --mode


       the mode of the plugin. select one of the following keywords:


       connection-time                  (Time to connect to the server)


       cpu-busy                         (Cpu busy in percent)


       io-busy                          (IO busy in percent)


       full-scans                       (Full table scans per second)


       connected-users                  (Number of currently connected users)


       transactions                     (Transactions per second (per database))


       batch-requests                   (Batch requests per second)


       latches-waits                    (Number of latch requests that could not be granted immediately)


       latches-wait-time                (Average time for a latch to wait before the request is met)


       locks-waits                      (The number of locks per second that had to wait)


       locks-timeouts                   (The number of locks per second that timed out)


       locks-deadlocks                  (The number of deadlocks per second)


       sql-recompilations               (Re-Compilations per second)


       sql-initcompilations             (Initial compilations per second)


       total-server-memory              (The amount of memory that SQL Server has allocated to it)


       mem-pool-data-buffer-hit-ratio   (Data Buffer Cache Hit Ratio)


       lazy-writes                      (Lazy writes per second)


       page-life-expectancy             (Seconds a page is kept in memory before being flushed)


       free-list-stalls                 (Requests per second that had to wait for a free page)


       checkpoint-pages                 (Dirty pages flushed to disk per second. (usually by a checkpoint))


       database-free                    (Free space in database)


       database-backup-age              (Elapsed time (in hours) since a database was last backupped)


       sql                              (any sql command returning a single number)


       list-databases                   (convenience function which lists all databases)


       list-datafiles                   (convenience function which lists all datafiles)


       list-locks                       (convenience function which lists all locks)





    --name


       the name of the database etc depending on the mode.


    --name2


       if name is a sql statement, this statement would appear in


       the output and the performance data. This can be ugly, so 


       name2 can be used to appear instead.


    --regexp


       if this parameter is used, name will be interpreted as a 


       regular expression.


    --units


       one of %, KB, MB, GB. This is used for a better output of mode=sql


       and for specifying thresholds for mode=tablespace-free





  Database-related modes check all databases in one run by default.


  If only a single database should be checked, use the --name parameter.


  The same applies to datafile-related modes.


  


  In mode sql you can url-encode the statement so you will not have to mess


  around with special characters in your Nagios service definitions.


  Instead of 


  --name="select count(*) from master..sysprocesses"


  you can say 


  --name=select%20count%28%2A%29%20from%20master%2E%2Esysprocesses


  For your convenience you can call check_mssql_health with the --encode


  option and it will encode the standard input.