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

⇐ Back to index