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

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index