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

Criteria for switching between synchronizing and synchronized state in database mirroring Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 9:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
Hi Everyone,

We have a Asynchronous Mirroring in SQL SERVER 2008 R2. What is the criteria that causes switching between synchronizing and synchronized states in database mirroring?Is there any specific threshold in unsent queue, that if we pass it ,the state will change from synchronized to synchronizing .I read in one blog that threshold is 1MB?Is it possible to change this threshold?



Thanks
Post #1395759
Posted Thursday, December 13, 2012 3:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 101, Visits: 110
There is no default threshold for datbase mirroring send queue or redo queue..

Please share the link you read.

http://msdn.microsoft.com/en-us/library/ms408393.aspx#PerfMetricsAndWarningThresholds



Regards,
RamaSankar
MCTS,MCITP











Post #1396088
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse