Server differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences between the two servers.

To query the Performance Store database for differences between two servers, use:

exec dbo.s_server_diff '[server 1]', '[server 2]'

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.