HADR_TRANSPORT_SESSION

Description

For databases participating in an Availability Group. This wait type will accumulate while reading or changing the transport layer state. This can occur during failover, network issues and regular Availability Group health checks. This wait is common but values should be low. If values are high see the suggested solutions below

Resolved by

DBAs and Developers

Suggested solutions

  1. Check the SQL Server error log for more information
  2. Examine Windows Failover Clustering logs
  3. Examine wait statistics on the instance for other Availability Group issues. Investigate accordingly

Additional research

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