NSClient MSSQL

NSClient MSSQL Profile

This profile monitors a Microsoft SQL Server using NSClient. NSClient 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 Info - 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
nsclient_mssql_bufcache_ hits	check_nt_counter_mssql_ bufcache_hits!80!50	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Buffer Manager Buffer cache hit ratio", "SQLServer:Buffer Manager Buffer cache hit ratio is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_deadlocks	check_nt_counter_mssql_ deadlocks!10!20	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Locks(_Total) Number of Deadlocks/sec", "SQLServer:Locks(_Total) Number of Deadlocks/sec is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_latch_ waits	check_nt_counter_mssql_ latch_waits!50!100	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Latches Latch Waits/sec", "SQLServer:Latches Latch Waits/sec is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_lock_ wait_time	check_nt_counter_mssql_ lock_wait_time!10!20	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Locks(_Total) Lock Wait Time (ms)", "SQLServer:Locks(_Total) Lock Wait Time (ms) is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_lock_ waits	check_nt_counter_mssql_ lock_waits!50!100	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Locks(_Total) Lock Waits/sec", "SQLServer:Locks(_Total) Lock Waits/sec is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_log_growths	check_nt_counter_mssql_ log_growths!10!20	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Databases(_Total) Log Growths", "SQLServer:Databases(_Total) Log Growths is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_ log_used	check_nt_counter_mssql_ log_used!10!20	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Databases(_Total) Percent Log Used", "SQLServer:Databases(_Total) Percent Log Used is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_memory_ grants_pending	check_nt_counter_mssql_ memory_grants_pending!10!20	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l " SQLServer:Memory Manager Memory Grants Pending", "SQLServer:Memory Manager Memory Grants Pending is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
nsclient_mssql_ transactions	check_nt_counter_mssql_ transactions!10!20	$USER1$/check_nt -H $HOSTADDRESS$ -p $USER19$ -s $USER4$ -v COUNTER -l "\\SQLServer:Databases(_Total) Transactions/sec", "SQLServer:Databases(_Total) Transactions/sec is %.f " -w "$ARG1$" -c "$ARG2$"	number_graph
tcp_nsclient	check_nt	$USER1$/check_nt -p $USER19$ -s $USER4$ -H $HOSTADDRESS$-v CLIENTVERSION	number_graph

Profile Package

This package includes the following files:

Profile Definitions

service_profile_nsclient_MSSQL.xml
perfconfig_nsclient_MSSQL.xml

Plugins Scripts

check_nt

NSClient scripts (installed on the monitored Windows Server)

nsclient.zip

Performance Graphing Programs

number_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

This section contains detail settings used by this Profile. These parameters can be altered with the Configuration tool.

Command Parameters

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

nsclient_mssql_bufcache_hits

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 80
$ARG2$ - Critical threshold, default is 160

nsclient_mssql_deadlocks

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

nsclient_mssql_latch_waits

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 50
$ARG2$ - Critical threshold, default is 100

nsclient_mssql_lock_wait_time

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

nsclient_mssql_lock_waits

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 50
$ARG2$ - Critical threshold, default is 100

nsclient_mssql_log_growths

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

nsclient_mssql_log_used

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

nsclient_mssql_memory_grants_pending

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

nsclient_mssql_transactions

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and execute the COUNTER command.
$ARG1$ - Warning threshold, default is 10
$ARG2$ - Critical threshold, default is 20

tcp_nsclient

Uses check_nt plugin to connect to NSClient on $HOSTADDRESS$ and retrieve the version number.
No arguments.

Performance Graphing Parameters

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