Criteria for switching between synchronizing and synchronized state in database mirroring

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  December 12, 2012 at 9:18 am

  #393788

  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

• Ramasankar Molleti

  Ten Centuries

  Points: 1044

  More actions

  December 13, 2012 at 3:30 am

  #1568227

  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