Monitoring MS SQL in Nagios

We have installed a MS SQL Server in your department.  I am wondering how I can get Nagios to monitor the MSSQLSERVER service?

Thanks,
Mikie
csg_int_itAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
WizRd-LinuxConnect With a Mentor Commented:
You can now find the plugin called check_mssql.sh in the contrib/ subdirectory of the latest plugin distribution that will check MS SQL servers.

The latest version is avaliable from sourceforge.
0
 
digital_thoughtsCommented:
0
 
WizRd-LinuxCommented:
If you want to monitor the server download and install the nscd windows service, configure it to check windows services, then you can configure you nagios box to query the "service"

Unfortunately I don't have a good example right now, but if you get stuck, please post back and I will help you move forward.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
csg_int_itAuthor Commented:
digital_thoughts,
I saw the same posting but haven't been able to find the check_mssql.sh plugin.

Mike
0
 
sardiskanCommented:
You need to install the NSclient package on the windows server, from there you can do a check to make sure MSSQL is running. That client might enable you to find detailed information about MSSQL as well.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.