How to monitor MS SQL Server database using nagios

An open discussion forum for obtaining help with Nagios Core. Nagios Core users of all experience levels are welcome here. Subforum have been created for the discussion of Nagios Core and Nagios Plugin development.

NOTE: The SourceForge.net mailing lists have been deprecated in favor of this forum in order to expedite support and provide additional features not available on the old mailing list.

How to monitor MS SQL Server database using nagios

Postby ravis007 » Wed Mar 24, 2010 5:47 am

Hi,
I am using nagios for monitoring all my remote linux & windows machines.
Now I want to monitor MS SQL Server database using nagios.
My requirement is like -
I have one database in MS SQL Server containing 10 employees.
So I want to monitor if 10 employees are present there, then nagios should show status OK for MS SQL Server.
And id there are less employees into the database, then it should give alert or critical message.

For doing this all, what I have to.
Please tell me detailed steps to do this or provide me the pointers for this.

Please Help.
Thanks in advance.
ravis007
 
Posts: 1
Joined: Wed Mar 24, 2010 5:39 am

Re: How to monitor MS SQL Server database using nagios

Postby mmestnik » Wed Mar 24, 2010 12:38 pm

You are looking to do content checks against MS SQL?

I don't think we've ever done that, but there are many tools for working with MS SQL perhaps one of them can help.

Take a look here:
http://exchange.nagios.org/
http://exchange.nagios.org/directory/Plugins/Databases/Others/check_sql/details
mmestnik
 
Posts: 972
Joined: Mon Feb 15, 2010 2:23 pm


Return to Nagios Core

Who is online

Users browsing this forum: SOIConsoleMonitoring and 37 guests