November 10, 2011 at 10:15 am
Hi,
I'm looking for a tool to compare instance level settings of the server such as mail profiles, MAXDOP, etc. I've tried googling and have many hits for database level comparison tools but none for instances. Anybody know of one?
Thanks,
Scott
November 10, 2011 at 11:38 am
I don't know of one, but the owners of this site are into building SQL DBA tools. Might suggest it to them as an idea. (redgate is the company that owns this site.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 10, 2011 at 11:59 am
I'm surprise no one has one, trying to identify differences between multiple dev instances, DR/HA instances and prod can be a pain.
November 11, 2011 at 6:47 am
Would also be great for confirming Test and QA servers are set up to parallel Prod.
I suggested it to Redgate. They don't have such a tool, but it'll get mentioned at their next product planning meeting.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 14, 2011 at 7:55 pm
Thank you sir!
November 15, 2011 at 3:39 am
I know Spotlight on SQL Server Enterprise from Quest has a "configuration" tab, but you have to look at it at sever level you cannot compare side by side (unless you open multiple clients) , the limitation to this is that its just like running sp_configure on each server, so it doesnt go down to stuff like mail profiles etc, but gets MAXDOP etc
December 4, 2011 at 11:22 pm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply