Solved

Monitor Microsoft SQL cluster disk and services with Nagios?

Posted on 2011-02-17
3
2,459 Views
Last Modified: 2013-11-13
I setup a Windows/SQL 2008 cluster and have Nagios all setup. The problem is that the disks and services on the passive node show critical or unknown because they are not there or stopped. I am looking for a way to monitor the disks and services from a cluster level so I don't have anything showing down.

I found the following URL but I don't see anything about services. I also tried setting it up and was unsuccessful.

http://exchange.nagios.org/directory/Plugins/Uncategorized/Operating-Systems/Windows-NRPE/check_mscs-2Evbs/details
0
Comment
Question by:ThorinO
[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
  • 2
3 Comments
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 34919517
You should configure the nagios to probe the sqlcluster IP only and depending on whether you have three instances of the nagios agent.
One runs on the each node
And one that is part of the cluster resource binds to the cluster IP
This way you can monitor each node individually and then you check the clustered instance for the cluster related resources.
I'd think you want to know when the passive node is down.
0
 
LVL 10

Author Comment

by:ThorinO
ID: 34920344
OK that makes sense, I created another host with the cluster resources and removed them from the nodes but am still monitoring other things on the nodes.

Another question you might know, it would be cool to have Nagios check to see what the active node is. So like some check on the cluster to check for the hostname, and if the hostname does not equal node 1 (primary) then it goes critical. I figure since I want it on node 1 most of the time that it would be nice to know if it fails over for some reason.
0
 
LVL 78

Expert Comment

by:arnold
ID: 34920834
You would run a check on the hostname=yourpreferred node.
Within the nagios script you have on the Windows server a check for name that will ouput the %COMPUTERNAME%

Alternatively, You could configure the cluster such that node 1 is primary which will result in failback when the primary node comes back.  
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IMAP copying tool 14 49
Java Inheritance super keyword use 8 40
Assigning Database Principals to Database Roles 3 19
sql server major issue  need help 2 53
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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

730 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