Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks

share|improve this question

migrated from stackoverflow.com Jun 18 '10 at 5:22

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

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

4 Answers 4

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

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

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
add comment

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
add comment

Red Gate's tool can be found at:

http://www.red-gate.com/products/SQL_Response/index.htm

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
add comment

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
add comment

Your Answer

 
discard

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.