Solved

Monitoring MS SQL in Nagios

Posted on 2007-12-04
6
12,204 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Transparency shows that a company is the kind of business that it wants people to think it is.
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

622 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