Can someone help me figure out if my understanding is correct on the below:
On the AG Dashboard for my readable secondary replica I see:
- Estimated recovery time (secs) - 4598
- REDO queue - almost 24 GB
So what exactly does it mean if my secondary AG needs to go for node/failover or SQL restart as part of an activity?
Does it mean my secondary will take 4598 secs to bring this DB up with redo queue 24 GB?
I am concerned because one of our prod sec side has most of time during day time redo size of 400 GB and recovery time almost 10 hours from AG dashboard. Does it mean so called DR is compromised?
I just did a test failover and as expected DB went for recovery as I see from error log messages and see it completing in 1235 secs. Just curious as that number of estimated recovery was way off. This is just to explain my business users help them what outage window we are talking about.