central management for SQL Servers

• oferhai

  SSC Enthusiast

  Points: 149

  More actions

  November 1, 2010 at 2:55 am

  #242469

  hi,

  We have about 50-60 servers running SQL Servers (2000,2005,2008 versions) on our company.

  can you recommend us a good proven product (not a SQL Server tool) to manage

  all of these 50-60 servers from one central console with capabilities of administration and performance?

  Thank you

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  November 1, 2010 at 2:07 pm

  #1245064

  What you mean a gud proven product and not sql server(third party) tool??

• alanspeckman

  Hall of Fame

  Points: 3344

  More actions

  November 1, 2010 at 2:17 pm

  #1245072

  I have not used it in a long time, but TOAD is a very powerful tool to use. It is great if you are a developer too.

  http://www.quest.com/toad-for-sql-server/

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  November 1, 2010 at 2:17 pm

  #1245073

  SSMS does a good job of administration. I'm not sure of a better one. In terms of performance, you have a few choices:

  Red Gate is releasing SQL Monitor next week, which is built on SQL Response. That's more for monitoring/alerting.

  Quest has some good tools in Spotlight/Foglight that can help.

  SQL Sentry has Performance Advisor, which can work out.

  Embarcadero has some nice admin tools, but they essentially replace SSMS. Not sure it's that much better.