check_mssql_health

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

You must be logged in to submit a review.

Your review has been submitted and is pending approval.

Your recommendation has been sent.