Take the 2-minute tour ×
Server Fault is a question and answer site for 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

closed as off-topic by Tom O'Connor Jun 2 at 10:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they tend to become obsolete quickly. Instead, describe your situation and the specific problem you're trying to solve." – Tom O'Connor
If this question can be reworded to fit the rules in the help center, please edit the question.

4 Answers 4

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

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

I've demoed a few of the Quest products:

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

share|improve this answer

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

protected by Tom O'Connor Jun 2 at 10:44

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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