Post reply

Clustering

  • October 21, 2004 at 7:59 am

    #86786

    What are some of the common events which cause SQL Server to failover in an Active/Passive configuration? What are some of the 'gotchas' to look out for in this configuration?  

  • October 21, 2004 at 10:52 am

    #527502

    Extremely high loads for long periods may cause the hartbeat to fail for long periods and may cause a failover. I haven't seen it happen often but it can. Anything that causes the SQL Server service to fail will cause a failover. Agent failure will not cause a failover unless you set it to do so. Other than that I can't think of any real "gotchas"

  • October 22, 2004 at 4:49 am

    #527616

    stopping and starting services out of Cluster admin will cause a failover.

    any interruption to the network connections including heartbeat.

    putting msdb in dbo only mode can cause problems.

    losing a san drive ( temporarily ) can cause failover.

    re-booting a tape library device  that works on the san the sql cluster is attached to gave me problems.

    other than that I can't think of much else - applying patches can sometimes be interesting!

     

     

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 26, 2004 at 3:40 pm

    #528071

    Thank you Wesley and Colin for your posts. They are much appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply