Criteria for switching between synchronizing and synchronized state in database mirroring

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Criteria for switching between synchronizing...

Criteria for switching between synchronizing and synchronized state in database mirroring

Rate Topic

Display Mode

Topic Options

Author

Message

Aspet Golestanian Namagerdi

Posted Wednesday, December 12, 2012 9:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:30 PM
Points: 174, Visits: 661

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

sankar276

Posted Thursday, December 13, 2012 3:30 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:05 PM
Points: 99, Visits: 98

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 »

Permissions