tigertoolbox/Always-On/failover

Failover Analysis

This section has information on how to use the various logs available for Always On Availability Groups when performing a post mortem analysis of a failover.

Failover.pbix - The PowerBI Desktop file which has the necessary visualizations for perfoming possible root cause analysis by extracting data from the SQLDIAG Extended Event traces available in the LOG folder.

A recording of the PASS webinar where this dashboard was presented is available on YouTube