Monitoring MS SQLServer 2005 with Nagios

Need to monitor a SQLserver with Nagios? There’s check_mssql.sh in the latest nagios plugins’ contrib folder. This check command only works with SQLServer 7 and 2000, though.

To make it work with SQLServer 2005, you only need to change 1 line in the script. Find this line:

echo -e "select loginame from sysprocesses where spid > $spid ...

and change it to

echo -e "select loginame from sys.sysprocesses where spid > $spid ...

Now, if your freetds installation (the actual SQLServer client that does all the magic) supports SQLServer 2005, you can run the script as though you’re checking a SQLServer 2000 installation.

Tags: Monitoring, Nagios

This entry was posted on Monday, May 5th, 2008 at 7:53 pm and is filed under Nagios, Work. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

2 Responses to “Monitoring MS SQLServer 2005 with Nagios”

Dan Ovidiu says:

March 18, 2009 at 11:55 pm

Hi, a new plugin came out this week (one of a whole family of database-monitoring-plugins). http://www.consol.de/opensource/nagios/check-mssql-health
It is really feature-rich.
Dan
sql training says:

June 6, 2012 at 10:50 am

impressive technical knowledge. It just helped me today. thanks.