Server configuration differences

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

Server configuration differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the configuration between the two servers. It is a common problem that the server settings are different between two failover nodes.

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

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

Note, this is different from “Server differences” in the following way:

  • “Server differences” shows differences in operating system, SQL Server version, trace flags, startup types, etc.
  • “Server configuration differences” shows differences in memory settings, optimize for adhoc workloads, Ole Automation, 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