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

Primary- and secondary availability groups on same server

To query the Performance Store database for servers with both primary- and secondary availability groups placed on the same server, use:

select s.*
from dbo.v_servers s
where s.availability_group_info = 'AG_MIXED'

Due to SQL Server licensing, servers must only contain availability groups that are either either primary or secondary.

For at description of the different availability_group_info values, see SQL Server with databases not in availability group.

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