Download & Install

http://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Server-Centric-Status/details

License: GPL

Download:

mkdir

wget https://github.com/NagiosEnterprises/check_mssql_collection/archive/mast...

unzip master.zip

http://assets.nagios.com/downloads/nagiosxi/docs/Nagios_XI_Installing_MSSQL_Wizard_Prereqs.pdf

Examples

# Login Test

./check_mssql_server.py -H 192.168.0.1 -U user -P password

    OK: Time to connect was 0.00482892990112s|time=0.00482892990112s;;;;;

Mode Options:

ie.

./check_mssql_server.py -H 192.168.0.100 -U sa -P password --lazywrites

./check_mssql_server.py -H 192.168.0.100 -U sa -P password --lockwaits

./check_mssql_server.py -H 192.168.0.100 -U sa -P password --deadlocks

./check_mssql_server.py -H 192.168.0.100 -U sa -P password --batchreq

./check_mssql_server.py -H 192.168.0.100 -U sa -P password --locktimeouts

More

• --bufferhitratio Buffer Cache Hit Ratio
• --pagelooks Page Lookups Per Second
• --freepages Free Pages (Cumulative)
• --totalpages Total Pages (Cumulative)
• --targetpages Target Pages
• --databasepages Database Pages
• --stolenpages Stolen Pages
• --lazywrites Lazy Writes / Sec
• --readahead Readahead Pages / Sec
• --pagereads Page Reads / Sec
• --checkpoints Checkpoint Pages / Sec
• --pagewrites Page Writes / Sec
• --lockrequests Lock Requests / Sec
• --locktimeouts Lock Timeouts / Sec
• --deadlocks Deadlocks / Sec
• --lockwaits Lockwaits / Sec
• --lockwait Lock Wait Average Time (ms)
• --averagewait Average Wait Time (ms)
• --pagesplits Page Splits / Sec
• --cachehit Cache Hit Ratio
• --time2connect Check Time to Connect [DEFAULT]
• --batchreq Batch Requests / Sec
• --sqlcompilations SQL Compilations / Sec
• --fullscans Full Scans / Sec
• --pagelife Page Life Expectancy