HADR_GROUP_COMMIT

Description

This wait type is only used for databases participating in an Availability Group. When multiple log records can be batched together SQL Server can optimize distribution to replicas by performing a group commit. When SQL Server is waiting for the group commit to complete this wait will accumulate. As this wait type accumulates during an optimization (group commit) values in this counter are expected and do not indicate an issue

Resolved by

DBAs

Suggested solutions

  1. Safe to ignore
  2. Examine other Availability Group wait statistics on the instances

Additional research

Monitor SQL Server AlwaysOn Availability Groups
MSDN Blog: Monitor Performance for 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