HADR_RECOVERY_WAIT_FOR_CONNECTION

Description

For databases participating in an Availability Group. This wait type will accumulate when secondary replica is waiting to connect to primary replica. This most often occurs when the primary replica is taken offline (for whatever reason) or the network connection goes down. For SQL Server versions before 2014 secondary replicas are not readable when the primary is not available, this leads to downtime for readable workloads. If this wait type has high values it means the SQL Server could be running exposed to data loss (if the Availability Group is configured to two nodes)

Resolved by

DBAs

Suggested solutions

  1. Check the SQL Server error log for more information
  2. Examine Windows Failover Clustering logs to determine why the secondary replica is losing connection to the primary

Additional research

Why Your SQL Server’s Network Connection Matters
Monitor SQL Server AlwaysOn Availability Groups

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index