Decrease time needed to failover to mirror database RRS feed

  • Question

  • For our .NET webapplications we have setup database mirror using a witness. The connectionstring contains the Failover Partner key. All is working fine, however when failing over to the mirror database (in case the master is not available) it takes a large amount of time (more then 2 minutes). Do you have some advice/tips on how to decrease the time needed to switch over to the mirror?



    Thursday, December 23, 2010 10:40 AM


All replies

  • Just a guess , What is the time out setting in your .net apps connection string ? Are you seeing the slowness once the failover has happended and the mirrored copy assuming the primary role or before the failover initiates ?

    Thanks, Leks
    Thursday, December 23, 2010 7:59 PM
  • Also please read this article


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by WeiLin Qiao Friday, December 31, 2010 10:45 AM
    Sunday, December 26, 2010 7:01 AM