December 23, 2010 at 3:46 am
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
January 3, 2011 at 1:04 pm
Are you using Synchronous or Asynchronous mode? Synchronous requires (2) two hops to commit while async requires only (1) one.
January 4, 2011 at 1:17 am
Hi,
normally in synchronious mode it schould default failover in 10 seconds (time to be sure the master is down) + time to switch over (normally some ms).
see "select * from sys.database_mirroring" and verify column "mirroring_connection_timeout".
How big is the database? Are there many changes to deploy on mirror? Perhaps the queue of the mirror is full until the failover happen.
Greets
pitcher
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply