NRPE MSSQL

NRPE MSSQL Profile

This profile monitors a Microsoft SQL Server using Nagios Remote Plugin Executor (NRPE). NRPE is used by the Nagios server to communicate with the Windows server.

Services Configuration

Service - Definitions in Monarch are stored under this name.
Command Line - Service command name with arguments to be passed to the plugin.
Plugin Command Line - Plugin script called by Nagios for this Service.

Extended Infor - The Extended Service Info definition, typically used for generating graphs.

Command lines displayed below are intended to be single line commands.

Service	Command Line	Plugin Command Line	Extended Info
nrpe_mssql_buffer_cache_hits	check_nrpe_mssql_buffer_cache_hits!80!50	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_buf_cache_hit -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$"	number_graph
nrpe_mssql_deadlocks	check_nrpe_mssql_deadlocks!Name= _Total!50!100	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_deadlocks -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	number_graph
nrpe_mssql_full_scans	check_nrpe_mssql_full_scans!10!20	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_fullscans -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$"	number_graph
nrpe_mssql_lock_wait_time	check_nrpe_mssql_lock_wait_time!Name= _Total!1000!1500	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_lock_wait_time -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	number_graph
nrpe_mssql_lock_waits	check_nrpe_mssql_lock_waits!Name= _Total!4!6	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_lock_waits -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	number_graph
nrpe_mssql_log_growths	check_nrpe_mssql_log_growths!Name= _Total!5!8	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_log_growth -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	number_graph
nrpe_mssql_log_used_db_master	check_nrpe_mssql_log_used!Name= master!30!40	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_log_used -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	percent_graph
nrpe_mssql_log_used_db_model	check_nrpe_mssql_log_used!Name= model!40!50	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_log_used -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	percent_graph
nrpe_mssql_log_used_db_msdb	check_nrpe_mssql_log_used!Name= msdb!40!50	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_log_used -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	percent_graph
nrpe_mssql_log_used_db _mssqlsystemresource	check_nrpe_mssql_log_used!Name= mssqlsystemresource!40!50	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_log_used -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	percent_graph
nrpe_mssql_log_used_db_tempdb	check_nrpe_mssql_log_used!Name= tempdb!40!50	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_log_used -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	percent_graph
nrpe_mssql_memory_grants_pending	check_nrpe_mssql_memory_grants _pending!1!5	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_memgrantspending -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$"	number_graph
nrpe_mssql_transactions	check_nrpe_mssql_transactions!Name= _Total!10!20	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_transactions -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	number_graph
nrpe_mssql_users	check_nrpe_mssql_users!1!5	$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -c get_mssql_users -a "$HOSTADDRESS$" "$ARG1$" "$ARG2$" "$ARG3$"	number_graph
nrpe_service_DcomLaunch	check_nrpe_service!DcomLaunch	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph
nrpe_service_Dfs	check_nrpe_service!Dfs	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph
nrpe_service_msftesql	check_nrpe_service!msftesql	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph
nrpe_service_MSSQLServerADHelper	check_nrpe_service!MSSQLServerADHelper	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph
nrpe_service_SQLBrowser	check_nrpe_service!SQLBrowser	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph
nrpe_service_SQLSERVERAGENT	check_nrpe_service!SQLSERVERAGENT	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph
nrpe_service_W32Time	check_nrpe_service!W32Time	$USER1$/check_nrpe -H $HOSTADDRESS$ -t 60 -c get_service -a "$HOSTADDRESS$" "$ARG1$"	percent_graph

Profile Package

This package includes the following files:

Profile Definitions

service_profile_nrpe_MSSQL.xml
perfconfig_nrpe_MSSQL.xml

Plugins Scripts

check_nrpe

NRPE scripts (installed on the monitored Windows Server)

nrpe_nt.zip

Performance Graphing Programs

number_graph.cgi
percent_graph.cgi

Installation

GroundWork Monitor includes many monitoring profiles for a variety of devices, systems and applications. Profiles already imported on a new GroundWork installation include Service Ping, SNMP Network, and SSH UNIX. The GroundWork Monitor Configuration tool is used to import updated Profiles and Profiles that require additional setup; the Profile XML file and its companion Performance Configuration definition file. Services can also be imported in addition to Service Profiles in the Profile Importer. The import process is documented under GROUNDWORK PROFILES > How to import profiles.

Implementation

Command Parameters

Command parameters are in the Configuration Services section with the following names and default values.

nrpe_mssql_buffer_cache_hits

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_buf_cache_hit command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 80
$ARG3$ - Critical threshold, default is 160

nrpe_mssql_deadlocks

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_deadlocks command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 50
$ARG3$ - Critical threshold, default is 100

nrpe_mssql_full_scans

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_fullscans command as defined in nrpe.cfg.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

nrpe_mssql_lock_wait_time

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_lock_wait_time command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 1000
$ARG3$ - Critical threshold, default is 1500

nrpe_mssql_lock_waits

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_lock_waits command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 4
$ARG3$ - Critical threshold, default is 6

nrpe_mssql_log_growths

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_log_growth command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 5
$ARG3$ - Critical threshold, default is 8

nrpe_mssql_log_used_db_<INSTANCENAME>

nrpe_mssql_log_used_db_master

nrpe_mssql_log_used_db_model

nrpe_mssql_log_used_db_msdb

nrpe_mssql_log_used_db_mssqlsystemresource

nrpe_mssql_log_used_db_tempdb

Where INSTANCENAME is equal to the database instance name on the target host.
Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_log_used command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is INSTANCENAME
$ARG2$ - Warning threshold, default is 30/40
$ARG3$ - Critical threshold, default is 40/50

nrpe_mssql_memory_grants_pending

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_memgrantspending command as defined in nrpe.cfg.
$ARG1$ - Warning threshold, default is 1
$ARG2$ - Critical threshold, default is 5

nrpe_mssql_transactions

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_transactions command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 10
$ARG3$ - Critical threshold, default is 20

nrpe_mssql_users

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_mssql_users command as defined in nrpe.cfg.
$ARG1$ - Database Instance, default is _Total
$ARG2$ - Warning threshold, default is 1
$ARG3$ - Critical threshold, default is 5

nrpe_service

Uses check_nrpe plugin to connect to NRPE on $HOSTADDRESS$ and execute the get_service command as defined in the nrpe.cfg.
$ARG1$ - Service Name (not Display Name!)
OK if service is running
CRITICAL is service is stopped.
UNKNOWN is service is not installed.

Performance Graphing Parameters

The following parameters are used to generate performance charts. These parameters are set using the Configuration>Performance tool in GroundWork Monitor.