SQL Server Performance

Identify failover event?

Discussion in 'SQL Server Clustering' started by sql_er, Jul 26, 2007.

  1. sql_er New Member

    Guys,

    We have active/passive cluster set up. There are 2 machines in a cluster. If machine 1 fails, machine 2 takes over, with no fail back.

    We had an issue recently - there was a failover, but we never knew about it since SQL Server was working with no problem, until some point in time. This point in time occurred when we began to run out of disk space on a disk to where we back up db and transaction log. Apparently we did not compress the drive on the 'to fail over to' machine.

    Can anyone share, from their experience, how one can identify and alert if a failover occurs?

    Thanks a lot
  2. MohammedU New Member

    There is no built in option to get the alerts but you can setup one...

    Simple one is install sql mail and configure to send an email when the sql agent restarted...


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    Being a DBA or System Admin you must follow in observing the event viewer & SQL Server error log every day. Otherwise do need have a third party tool or performance generated alerts using SYSMONhttp://www.databasejournal.com/features/mssql/article.php/1502191 fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page