5 pts.
 What are the best tools for SQL monitoring and SQL diagrams?
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

Software/Hardware used:
ASKED: December 8, 2010  10:51 PM
UPDATED: December 16, 2010  2:23 PM

Answer Wiki:
I like the Idera SQL Diagnostic Manager for monitoring SQL Servers, especially in an enterprise environment with lots of servers. I will let others comment on SQL diagrammers - there are several available, and they all have their pros and cons.
Last Wiki Answer Submitted:  December 9, 2010  7:45 pm  by  Kccrosser   3,830 pts.
All Answer Wiki Contributors:  Kccrosser   3,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Take a look at Quest Software’s Spotlight on SQL Server Enterprise. It is very inexpensive compared to Idera’s Diagnostic Manager. As for diagramming, use the built in diagrammer that comes with MS SQL.

 25 pts.

 

Hi – I work for Red Gate Software, so have an obvious bias here, but we have a new SQL Monitoring tool out, SQL Monitor, which may be the sort of thing you’re looking for. We have an online, live demo at:

Feel free to take a look!

 10 pts.