Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi I currently loook after 20 odd databases in SQL server 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job.


share|improve this question

migrated from Jun 18 '10 at 5:22

This question came from our site for professional and enthusiast programmers.

You'll probably get more and better answers on - that's where the DBA's and monitoring guys hang out, more so than here... – marc_s Jun 17 '10 at 13:45
check out SCOM from MS, and products from RedGate and Idera – Mitch Wheat Jun 17 '10 at 13:45

Check out the Quest tool suite for SQL Server Management and Monitoring:

Check out Spotlight on SQL Server - I would think that's roughly what you might be looking for (but I'm not a full-time DBA or systems admin....)

share|improve this answer

On the free:

SQLMonitoring Tool

SQL Server 2005 Performance Dashboard Reports

Confio Ignite Free - Check this one out. It is amazing! The free version will monitor up to twenty instances. Based on the size of your environment, I think this will do everything you need and more.

share|improve this answer

Red Gate's tool can be found at:

To be clear, I work here at Red Gate, so I would plug our tool, but - we have a fully functional 14 day trial. Try it out and see what you think..

share|improve this answer

Two freebies you already have, Perfmon and Profiler will do everything you need, I've used them alone to tune and monitor fairly large setups. Run Profiler to watch for long running queries, and run Perfmon to watch CPU and disk I/O ranges.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.