Database differences

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

Database differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the databases between the two servers. Even though a database that is a part of an availability group will reside on the primary server and the secondary server, there can still be differences like the owner of the database.

To query the Performance Store database for database differences, use:

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

It is also possible to use the Database Finder to quickly identify database differences, or to verify the integrity between two failover nodes. For more information see: Integrity between failover nodes.

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