How to compare settings of two DB servers?
-
I am trying to reproduce a problem that is probably related to how a particular SQL server is configured. Is there a tool or best practice that is useful to compare all of the configuration settings between two SQL Servers (same version)?
-e
-
Run the following on each instance and compare the output.
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE;
EXEC sp_configure;
Also run DBCC TRACESTATUS. There could be a traceflag set on one but not the other. If so, google that traceflag for info about it.
I was scratching my head for ages about a problem that I could not reproduce on any other instance. Traceflag was the cause.
-
query the sys.configurations catalog on each server to compare the server level settings
Select name, value_in_use from sys.configurations
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply