Do any of these questions sound familiar?
– My AG fails to failover
– Why did my AG failover?
– Why did my AG fail?
– My AG is missing!
– Why am I seeing stale data on secondary?
– What is with the sudden log growth alerts?
You are either hearing from end users that they are seeing stale data, or they are losing connections to availability database or listener, or you have monitoring solutions in place to catch these proactively and mitigate but are looking for a root cause. In either scenario, it helps to understand