HADR_DBSTATECHANGE_SYNC

Description

Occurs when databases inside an Availability Group states are synchronized. For example when a database receives a fail-over request the primary becomes synchronized and the secondaries shift into their preferred state (read-only, synchronizing, etc)

Resolved by

DBAs

Suggested solutions

  1. Some values are expected, if values are excessively high investigate SQL Server error log

Additional research

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide

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