Skip to main content
How can we help?
< All Topics
Print

Non-healthy server availability group state

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

select s.*
from dbo.v_servers s
where s.availability_group_all_healthy = 0

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