How to detect MSSQL cluster failover?

[Jim Avery]

2009/8/12 Marco Tirado <marco.tirado at gmail.com>:
> Hello users:
>
> I would like to know what is the easiest way to detect when a failover
> occurs in an MSSQL cluster. I need a simple check that tells me when our
> database cluster fails from physical node "X" to node physical node "Y"
>
> Has anybody done this? Maybe with a passive check?
>
> Any comments or suggestions are appreciated.


We've configured IBM Director to forward the alert for that situation
to Nagios using an SNMP trap.  (Of course this only helps you if you
happen to have IBM Director and have configured Nagios to handle
incoming traps).

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null