Idera SQL Diagnostic Manager 6.2 Review

  • Comments posted to this topic are about the item Idera SQL Diagnostic Manager 6.2 Review

  • Great review.

    We have been using SQLdm for quite a while now, focused on our main application and its DB server and it has provided timely and invaluable help when needed.

    It makes it real easy in most cases to pinpoint the issues, and a quick glance at certain screens can give you a wealth of data that would take quite a few DMV's and time to analyze the results.

    Now when the system users are experiencing issues we can just say with a quick look, and say "Nope, it's not the database" 🙂

    For better assistance in answering your questions, click here[/url]

  • Brad,

    What feature set are you referring to when you say "the only one on the market"?


  • Thanks for the kind words!

    I'm really not any kind of shill for any particular vendor, and was legitimately impressed with the product.


    I was talking about the 'Wait-state' feature set, which I hadn't seen anywhere else before. The products I compared for this were SQL Response and Foglight for SQL Server. I probably should have been more specific, as many of SQLdm's features are available in other products.

    Thanks again, I appreciate the SS community, and was glad to share some observations.

  • Brad,

    Sorry...i forgot my manners...I also thought your article was well written, and I thank you for sharing.

    As for the wait details, there is another product available that provides those details. If you are interested in doing another review I would love to arrange for you to get a trial version. Just let me know.


  • Thomas,

    No worries! Sure, I'd love to hear more. If anything, it's certainly made it clear to me that wait states need to be a part of the normal operational review cycle.

    Thanks again,


  • Thanks for the great article, Brad.

    We've been using SQLdm for a number of years, we like it a lot. The History Browser is handy, too.

    And we DBAs were glad when, a few versions back, they added Application Security to it, so that developers can use the tool from our Citrix site to view their environments' activities, etc.


  • Appreciate the positive feedback, Tim.

    I'm liking the idea of deploying a monitoring tool via Citrix, for developer use. Clever.

  • So I am evaluating products for my new job and I am trying to decide between this and TOAD. I'm leaning towards Idera. Does anybody prefer anything over DM?

  • Vertigo44 (11/16/2010)

    So I am evaluating products for my new job and I am trying to decide between this and TOAD. I'm leaning towards Idera. Does anybody prefer anything over DM?

    We use Idera DM at work. It really does do the job and does it pretty well. There are a few counters that I'd like to change out if I could, but overall, I'm happy with it.

    That said, I've made the attempt to either replace Idera or add to it with Confio Ignite. While it doesn't cover some of the more traditional monitoring quite as well as Idera, it's a step above on the wait state monitoring & T-SQL performance metrics.

    Sometimes, it comes down to the style of the tool as much as what it does.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • One other thing I would consider when evaluating a product is whether the reports and other metrics you generate are going to be shared with non-technical people or developers. We chose Ignite simply because folks can easily grasp the waits and see exactly what we are seeing on our end. With a little discussion, we can help determine the root cause and work towards fixing the issue, whether it be the code, storage waits, etc.

  • I appreciate the input on this; The SQL toolspace is crowded, so the more insight, the better.

    Thanks for reading my article,


  • The issue I find with SQL DM is Poor Support and lack of clear documentation in defining the Metrics on Reports. Most of the documentation are very vague.

Viewing 13 posts - 1 through 12 (of 12 total)

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