Troubleshoot SQL Server AlwaysOn Failures

Look into the following logs…

1. Critical Events from Failover Cluster Manager
2. Validate Cluster Report
3. Windows Event Viewer

Quick Action:

1. Update SQL Server to Latest Patch.
2. Reboot server on all nodes.

Critical Events from Failover Cluster Manager

Cluster -> Nodes -> Show Critical Events

Validate Cluster Report

Cluster -> Validate Cluster -> Run all test

Windows Event Viewer

Filter event to “Critical” and “Error”