Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

mirroring intervals for automatic failover Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 2:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:20 AM
Points: 40, Visits: 353
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
Post #1455886
Posted Thursday, May 23, 2013 4:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
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

Post #1455924
Posted Thursday, May 23, 2013 4:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:20 AM
Points: 40, Visits: 353
am asking automatic failover occurred due to network failure means how much time mirror as a principal .
Post #1455927
Posted Thursday, May 23, 2013 4:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
Perhaps I'm missing something here but I'm still not sure what you're asking
Post #1455929
Posted Thursday, May 23, 2013 5:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:20 AM
Points: 40, Visits: 353
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

Post #1455954
Posted Thursday, May 23, 2013 5:51 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
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
Post #1455960
Posted Thursday, May 23, 2013 6:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:20 AM
Points: 40, Visits: 353
i have another question PARTNER TIMEOUT how much to set for automatic fail over for 250 gb database
Post #1455972
Posted Thursday, May 23, 2013 6:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
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
Post #1455979
Posted Thursday, May 23, 2013 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 6:20 AM
Points: 40, Visits: 353
but this will play important role in automatic failover right
Post #1455980
Posted Thursday, May 23, 2013 6:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
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.

Post #1455986
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse