Solved

Monitoring MS SQL in Nagios

Posted on 2007-12-04
6
12,202 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

739 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