May 23, 2013 at 2:44 am
Hi,
in my production server i configured mirroring with automatic fail over in sql server 2008 r2 can anyone tel me how much interval want to set as per standard my database size is 250 gb
May 23, 2013 at 4:13 am
What do you mean by "Intervals"?
Mirroring is realtime which means that transactions are committed at both partners in realtime - Depending on your mirroring mode - Synchronous or Asynchronous
May 23, 2013 at 4:20 am
am asking automatic failover occurred due to network failure means how much time mirror as a principal .
May 23, 2013 at 4:26 am
Perhaps I'm missing something here but I'm still not sure what you're asking
May 23, 2013 at 5:36 am
automatic failover occured means principal database go to mirror and mirror database come to principal iam asking how much time take for mirror comes to principal my db size is 250 db
May 23, 2013 at 5:51 am
Ok - You mean, how long will it take for the Mirror to take over as the Principal
As far as I know, it should be instant
Remember that your mirroring session needs to be running in high-safety mode and must have a witness.
Have a look here
http://msdn.microsoft.com/en-us/library/ms189590(v=sql.105).aspx
May 23, 2013 at 6:27 am
i have another question PARTNER TIMEOUT how much to set for automatic fail over for 250 gb database
May 23, 2013 at 6:45 am
Partner Timeout is more to do with your network latency and how far Mirror and Partner are physically apart from each other - Database size plays little part here
May 23, 2013 at 6:48 am
but this will play important role in automatic failover right
May 23, 2013 at 6:53 am
Yes it will
Principal, Mirror and Witness constantly Ping each other - The Partner Timeout is how long after NOT receiving a reply must it perform an automatic failover. I think the default is 5 seconds..
If you change the timeout to a high amount, this will compromise how long it will wait to Failover automatically after a problem has occured at your Principal.
May 23, 2013 at 6:55 am
thanks for your update today my confusion is cleared
May 23, 2013 at 6:59 am
No Problem
😎
May 23, 2013 at 7:45 am
SQLSACT (5/23/2013)
Yes it willPrincipal, Mirror and Witness constantly Ping each other - The Partner Timeout is how long after NOT receiving a reply must it perform an automatic failover. I think the default is 5 seconds..
If you change the timeout to a high amount, this will compromise how long it will wait to Failover automatically after a problem has occured at your Principal.
Actually, default is 10 seconds. Depending on your network you may want to increase this to prevent false fail overs. At a previous employer we increased this time to 30 seconds because at 10 seconds we experienced fail overs due to network issues and our servers were in the same room.
We had no issues with this setting and if the principal server did go down the 30 second delay was also not a problem.
May 23, 2013 at 7:52 am
That's why I said "I think..." Wasn't sure - Thanks for clearing up
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply