Home Dashboard Directory Help
Search

SQL2012- AlwaysOn Failover takes hours if log can be generated at a high pace on Primary by Arnav Pyasi


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 774548
Opened: 12/17/2012 6:04:12 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

It is always possible to create a scenario in which secondary becomes a lot behind primary when using synchronous commit thus resulting in high estimated recovery time even when taking log backups every minutes. This happens when primary is generating log at a higher pace then secondary can apply the log at. We have been able to reproduce the scenario each time with the same test in which estimated (and actual) recovery time goes on increasing to as high a value as one wants.
Details
Sign in to post a comment.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
InitializeTest.sql 12/17/2012 3 KB
RunLoad.sql 12/17/2012 596 bytes