3

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

Andy
  • 199
  • 1
  • 6

4 Answers4

2

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....)

marc_s
  • 1,152
  • 4
  • 21
  • 35
1

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.

Kenneth
  • 111
  • 2
0

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..

0

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.

SqlACID
  • 2,176
  • 18
  • 18