I need to submit a requisition for SQL DBA tools before we run out of budget. From the top of my head, I can only think of RED GATE. Can you please suggest tools that you might have used or reviewed?
+2
A:
10 tools? I can only think of a couple myself
Quest LiteSpeed (compression)
SQL Compare (including data compare etc etc)
SQL Toolbelt (the whole red gate line)
SQL Prompt (intellisense for sql)
SQLMenace
2009-07-13 16:18:43
Just pulled out the number 10 from the air. Just looking for the most popular tools, so that my team can evaluate them and then we can put in a recommendation. Thanks for the help
Raj
2009-07-13 16:33:34
A:
I'm only used SSMS (in 7/2000 - EM and QA) with Visual Studio. Also I have used Lumigent Log Explorer, but Lumigent has stopped selling it.
Alex_L
2009-07-13 16:28:33
A:
Hi
Here is a free tool which might help -
SQLCheck (http://www.idera.com/Products/Free-Tools/SQL-check/) is a free performance dashboard by Idera.
cheers
Andriyev
2009-07-13 16:29:56
A:
In my last job I used Idera SQL Diagnostic Manager to monitor and manage 20 servers. In current job use Red Gate SQL Response for monitoring and Apex Diff tools for data and structure comparisons.
I like to pick and mix from various providers, but sometimes that not as easy as just getting one on your preferred suppliers list!
Kev Riley
2009-07-13 16:33:19
+2
A:
The most common are the Red Gate line you use and the Quest line (TOAD for SQL).
SSMS usualy does not scale to 120 servers to administer.
A free addition to SSMS is SSMS Toolpack.
And btw, this would probably be a better match for serverfault.com
Remus Rusanu
2009-07-13 16:35:55