Solved

Monitoring MS SQL in Nagios

Posted on 2007-12-04
6
12,189 Views
Last Modified: 2010-07-14
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
Comment
Question by:csg_int_it
6 Comments
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20407211
0
 
LVL 13

Expert Comment

by:WizRd-Linux
ID: 20407279
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
 

Author Comment

by:csg_int_it
ID: 20411265
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.

 
LVL 5

Expert Comment

by:sardiskan
ID: 20423017
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
 
LVL 13

Accepted Solution

by:
WizRd-Linux earned 250 total points
ID: 20423184
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
 
LVL 1

Expert Comment

by:BenyG
ID: 25329286
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question