locked
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?

    Thanks,

    Felix

    Thursday, December 23, 2010 10:40 AM

Answers

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
    Answerer
  • Also please read this article

    http://msdn.microsoft.com/en-us/library/ms187465.aspx


    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