-
Contained AG Not Synchronizing After Planned Failover: How ADR Saved Us
We had a SQL Server 2022 contained AG that consistently took exactly 10 minutes to recover after every planned manual failover. Not 9 minutes. Not 11. 10 minutes on the dot. Both replicas would sit in a Not Synchronizing state, every database showed Recovering, and our fastest path back to being online again was often…
-
Read-Only Routing Isn’t Working, What Gives?
Problem You want to implement read-only routing for your Always on Availability Group so your reading workloads can be offloaded from your primary replica to one of your secondary replicas. But when it comes time to test, your reading queries aren’t hitting your readable secondary replicas like you expected. What gives? Here are some things…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
DBA Unfiltered 