Search found 3 matches

by srai
Mon Jul 29, 2013 2:10 pm
Forum: Nagios XI
Topic: SQL Failover Cluster - "Failover" process monitoring...
Replies: 5
Views: 2856

Re: SQL Failover Cluster - "Failover" process monitoring...

Yes, I think that's the only best route to go on this issue. I just implemented the script in production after testing it few times... works!
by srai
Thu Jul 25, 2013 12:37 pm
Forum: Nagios XI
Topic: SQL Failover Cluster - "Failover" process monitoring...
Replies: 5
Views: 2856

Re: SQL Failover Cluster - "Failover" process monitoring...

This is what we have been doing and it does work this way... monitoring the virtual name instead of physical nodes.
However, we would like to know in real-time when a fail-over occurs on the cluster, helpful when it happens in off-hours, weekends or offdays

Thanks,
by srai
Thu Jul 25, 2013 11:25 am
Forum: Nagios XI
Topic: SQL Failover Cluster - "Failover" process monitoring...
Replies: 5
Views: 2856

SQL Failover Cluster - "Failover" process monitoring...

We have couple of SQL 2008 R2 Failover Clusters running in production that we have been monitoring via Nagios.
Is there a way to monitor Failover Cluster service itself, esp. is there a way Nagios can detect the actual Failover of the cluster and notify us?

Thanks,
Sharad