HADR_DATABASE_VERSIONING_STATE

Description

Occurs when Availability Group databases version state changes. This refers to row versioning, example read committed snapshot.

Resolved by

DBAs

Suggested solutions

  1. Small values are ignorable. However, if the values are large check the SQL Server error log for more information
  2. Ensure performance of volumes holding replica data and logs files is adequate

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