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

Database securables differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the database securables between the two servers. Even though database security is automatically synchronized, there might still be differences in securables in the system databases.

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

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

Securables can be synchronized between servers by executing the “create_statement” from the dbo.v_securables view.

A script for synchronizing securables between a primary and secondary can automatically be created. See Synchronize Availability Group objects for more information.

Note, this is different from “Database security differences” that shows differences in role memberships, logins, etc.

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