HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING

Description

Occurs while queries on secondary Availability Group databases are blocked by version state changes. This wait will only occur when a secondary replica is enabled for read operations

Resolved by

DBAs

Suggested solutions

  1. Small values are ignorable and most likely once-off. However, if the values are large check the SQL Server error log for more information

Additional research

Active Secondaries: Readable Secondary Replicas

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