Home Directory Plugins Databases Check MS SQL 2008 / 2012 Used Memory

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

Check MS SQL 2008 / 2012 Used Memory

Current Version
1.1.0
Last Release Date
2014-07-11
Compatible With
  • Nagios 3.x
  • Nagios 4.x
  • Nagios XI
Owner
License
GPL
Hits
69038
Files:
FileDescription
checkmssql.pycheck_mssql binary
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
This tool is written in Python and it uses Windows Performance Counters to get the MS SQL memory usage. Using the Perfmon counters makes it so that a SQL account isn't required.
Requires: NSClient++ w/ NRPE enabled & SQL Server Perfmon Counters.

Notes: NRPE requires "allow_arguments" and "allow_nasty_meta_chars" enabled.

Service Example:
define service {
use generic-service
hostgroups mssql-hosts
service_description Memory: MSSQL Usage
check_command check_mssqlmem!db_memory_calc!85!90!$HOSTNAME$
}

Command Exmaple:
define command{
command_name check_mssqlmem
command_line /usr/lib64/nagios/plugins/check_mssql -H $HOSTADDRESS$ -p 5666 -o $ARG1$ -w $ARG2$ -c $ARG3$ -a $ARG4$
}