IDERA SQL Diagnostic Manager Review

The capability to baseline the environment and define thresholds for alerting is definitely the most valuable feature in my opinion.

Valuable Features

The capability to baseline the environment and define thresholds for alerting is definitely the most valuable feature in my opinion. As an operational DBA, I don't write code but need to make sure the SQL servers are healthy, performing scheduled jobs and made aware when issues arise.

Improvements to My Organization

SQL monitoring time has been dramatically reduced AND our IT Infrastructure team has improved SQL maintenance and monitoring knowledge over time just by using SQL DM. The dashboard provides valuable health information at a glance and from there drilling in and finding the cause of issues is pretty straightforward. Our SQL server environment consists mainly of proprietary databases so it is vital that we are on top of performance, resources and job execution - SQL DM provides the view into all of this.

Room for Improvement

With basic SQL training in my history, I've found at times I needed to Google SQL counters, for example, to understand what was occurring or how to configure SQL DM to be useful. While support has helped out, it's not their job to teach SQL! The built in help works for general configuration of the product but sometimes lacks the descriptions needed for fully understanding the intent of particular settings.

Use of Solution

We first implemented version 4.X so at least 10 years.

Deployment Issues

The original deployment was straightforward and upgrades have become more streamlined along the way.

Stability Issues

In earlier versions we periodically needed to restart services but with each upgrade, stability has improved and I don't recall ever needing to restart the version we are using, which is a few versions behind at this point.

Scalability Issues

Not at all. We easily moved from a SQL server that also contained the application to running the app on our Infrastructure app server and the database on a shared SQL server. Adding licenses and new servers to the SQL DM environment is simple.

Customer Service and Technical Support

Customer Service:

Although I haven't contacted customer service often, the response has always been prompt, courteous and provided for our needs. Additionally, Idera is very good at keeping the customer up to date on Account Manager changes.

Technical Support:

Tech support has been contacted only a few times but I found them to be prompt, knowledgeable and helpful in their responses. There is a level of SQL knowledge that I, as a relative beginner in the SQL world, found very helpful!

Previous Solutions

No. We were floundering around with MS SQL counters, event logs, SQL trace and profiler and were basically in the dark.

Initial Setup

Straightforward. Install the app and repository and if using the console from a different machine, ie. your workstation, install the console. Launch the app and start base-lining. Adjust thresholds based on your needs and build alerts. The configuration remains through upgrades.

Implementation Team

We implemented in-house. It's a simple install and configuration is ongoing for the initial month or so until baselines are established and thresholds and alerts defined.

Pricing, Setup Cost and Licensing

License codes are provided by Account Managers and are required for installing or upgrading the product.

Other Solutions Considered

We looked at MOM but were already invested in Solarwinds Network Performance Monitor at the time so decided not to go with MOM just for the SQL piece. While Solarwinds had SQL Application Monitor at the time it was not as easy to install, configure or understand as SQL DM.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email