check_mssql_health

Project Notes

nagsrv$ check_mssql_health Please select a mode 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 [-h | --help] check_mssql_health [-V | --version] Options: --hostname the database server --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) 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 Examples: nagsrv$ check_mssql_health --mode mem-pool-data-buffer-hit-ratio CRITICAL - buffer cache hit ratio is 71.21% | ? ...? buffer_cache_hit_ratio=71.21%;90:;80: nagsrv$ check_mssql_health --mode batch-requests OK - 9.00 batch requests / sec |? ...? batch_requests_per_sec=9.00;100;200 nagsrv$ check_mssql_health --mode full-scans OK - 6.14 full table scans / sec |? ...? full_scans_per_sec=6.14;100;500 nagsrv$ check_mssql_health --mode cpu-busy OK - CPU busy 55.00% |? ...? cpu_busy=55.00;80;90 nagsrv$ check_mssql_health --mode database-free --name AdventureWorks OK - database AdventureWorks has 21.59% free space left |? ...? 'db_adventureworks_free_pct'=21.59%;5:;2:? ...? 'db_adventureworks_free'=703MB;4768371582.03:;1907348632.81:;0;95367431640.62 nagsrv$ check_mssql_health --mode database-free --name AdventureWorks --warning 700: --critical 200: --units MB WARNING - database AdventureWorks has 694.12MB free space left |? ...? 'db_adventureworks_free_pct'=21.31%;0.00:;0.00:? ...? 'db_adventureworks_free'=694.12MB;700.00:;200.00:;0;95367431640.62 nagsrv$ check_mssql_health --mode page-life-expectancy OK - page life expectancy is 8950 seconds |? ...? page_life_expectancy=8950;300:;180: This plugin requires installation of the DBD::Sybase Perl module!