Jeff Iannucci announces a new procedure:
SQL Server Availability Groups can be a great feature to help support your High Availability needs, but what happens when they fail to work as expected?
Do you have an expiring certificate on used by an endpoint? Do you have timeout settings that could contribute to unexpected failovers? Are you suffering from a high number of HADR_SYNC_COMMIT waits?
We’ve seen all those things happen, and like Marvin Gaye we’ve wondered: what’s going on? And we’ve wanted a tool to help us see if other clients were having these problems, and more.
Read on for more information and check it out yourself.