Non-healthy database availability group state

Comments are closed
How can we help?
< All Topics
Print

Non-healthy database availability group state

To query the Performance Store database for databases with a non-healthy availability group state, use:

select d.*
from dbo.v_databases d
where 1 = 1
and d.availability_group_name is not null and d.synchronization_state_desc != 'SYNCHRONIZED' and d.synchronization_health_desc != 'HEALTHY'

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents