September 24, 2014 at 2:46 pm
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
September 25, 2014 at 9:36 am
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.
September 26, 2014 at 5:17 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply