Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 12225
  • Last Modified:

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
0
csg_int_it
Asked:
csg_int_it
1 Solution
 
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
 
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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
 
WizRd-LinuxCommented:
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

Featured Post

Lessons on Wi-Fi & Recommendations on KRACK

Simplicity and security can be a difficult  balance for any business to tackle. Join us on December 6th for a look at your company's biggest security gap. We will also address the most recent attack, "KRACK" and provide recommendations on how to secure your Wi-Fi network today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now