ThorinO
asked on
Monitor Microsoft SQL cluster disk and services with Nagios?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
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.