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.

I'm looking into purchasing a SQL Server monitoring system.

It should work with 2005/2008.

We would like to monitor performance, availability, backups, jobs and various database issues (space)

What has worked for you?

share|improve this question
add comment

4 Answers

up vote 3 down vote accepted

Quest Software has a product called Spotlight.

Red Gate has a product called SQL Response.

I'm currently using both SQL Response and Quest Spotlight to monitor my SQL2000+ databases. They are both good: Spotlight saves playback data which is occasionally useful (don't forget about additional overhead) and their custom SSRS map pack is really good (ex. daily subscription for job failures report). What i like about SQL Response is it's ease of installation and configuration (especially email)... and the GUI feels really intuitive.

I have yet to try out Operations Manager/System Center Operations Manager to monitor my SQL boxes.

share|improve this answer
    
I used the beta of Response - I'll have to check it out again. It seemed pretty useful, but sure did generate a large amount of reports. –  Sam Sep 2 '09 at 22:11
add comment

There are two flavours of monitoring tool for SQL Server. An alerting tool which lets you know when some attention is needed, and a passive monitoring tool that can be used for live diagnostics, trending analysis, historical graphs, etc.

  • Spotlight is best at providing real time diagnostics and reports.
  • MOM/SQL Response is better at alerts - and perhaps even look at hp OpenView. I also use Idera's SQL Compliance Manager for security alerts.

I haven't played with the Idera tool yet.

You could even create your own monitoring with SQL Agent and SQL Mail.

share|improve this answer
    
Thanks Mark, We've got the home grown SSIS solution I've created, but it only runs a few times a day - looking to avoid sinking a bunch of time into writing and maintining, and most of all doubting my solution. –  Sam Sep 14 '09 at 23:34
add comment

I love Idera's DM product as well: Idera DM. There are a few good reviews on the web as well: Review 1 and Review 2

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.