LLI Wiki — My Digital Knowledge Base

Troubleshoot an availability group failover

Cluster log components, sources to check and Microsoft references to diagnose an unexpected Always On failover.

When an Always On availability group fails over unexpectedly, the diagnosis uses both the SQL Server logs and the Windows failover cluster logs. The table lists the component names that appear in those logs, and the list after it gives the places to look.

Components named in the cluster log

Term Meaning
RHS Resource Hosting Subsystem, the cluster process that hosts the resource DLLs
WER Windows Error Reporting
[RES], [hadrag] Prefixes of the cluster log lines written for Always On resources
hadrres.dll Always On availability group resource DLL
RCM Resource Control Manager, a component of the cluster service

Where to look

Get-ClusterLog -Destination C:\Temp\ClusterLogs

Lease timeouts

The Microsoft articles below explain how failover detection depends on the lease timeout of the availability group, and how to diagnose an unexpected failover.

References

Notes

Mastodon LLIMastodon SocialFosstodon