SQL Monitoring Software

Question

SQL Monitoring Software

Jon.Morisi

SSChampion

Points: 12846
More actions
November 8, 2012 at 1:51 pm

#269984

Hi,
I'm preparing to investigate several monitoring software products. Some of the key features I'm looking for are:
1. Ability to scrape Windows Application log for MSSQL Errors and alert
2. Ability to run and trend SQL Queries.
3. Ability to run and trend WMI objects.
Here's the list of software products I'm planning on looking at:
1. Idera[/url]
2. SQLSentry[/url]
3. Quest[/url]
4. RedGate[/url]
Has anyone done this sort of evaluation before? Know if any of them will do what I'm looking for? Have strong feelings for or against any of these products?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

George M Parker SSCertifiable Points: 5412 More actions · Answer 1

Jon.Morisi (11/8/2012)
Hi,
I'm preparing to investigate several monitoring software products. Some of the key features I'm looking for are:
1. Ability to scrape Windows Application log for MSSQL Errors and alert
2. Ability to run and trend SQL Queries.
3. Ability to run and trend WMI objects.
Here's the list of software products I'm planning on looking at:
1. Idera[/url]
2. SQLSentry[/url]
3. Quest[/url]
4. RedGate[/url]
Has anyone done this sort of evaluation before? Know if any of them will do what I'm looking for? Have strong feelings for or against any of these products?

While I'm sure all four are great products, we've gone with both Idera Diagnostic Manager and SQL Sentry (event manager and performance advisor). Of the two, SQL Sentry is my personal favorite and I use it regularly. I seem to have better luck finding what I am looking for in SQL Sentry than I do in Diagnostic Manager. The blocking sql tab in SQL Sentry has been worth its wait in gold on numerous occasions.

I also like the event manager calendar feature that allows you to create a single view of scheduled jobs across multiple servers and even include windows scheduled jobs. If you need a maintenance window, this makes it easy to find an open one.

Jon.Morisi SSChampion Points: 12846 More actions · Answer 2

I suppose I should add System Center Operations Manager with System Center Monitoring pack for SQL Server to the list.

bjcharles Old Hand Points: 366 More actions · Answer 3

I evaluated most of them before I went for Idera's DM and it's been great in terms of helping me easily spot issues.