Idera SQL Diagnostic Manager 6.2 Review

  • swellguy

    Mr or Mrs. 500

    Points: 526

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

  • Richard M.

    SSCertifiable

    Points: 7287

    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]

  • SQLRockstar

    SSCertifiable

    Points: 5960

    Brad,

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

    ----------------------
    https://thomaslarock.com

  • swellguy

    Mr or Mrs. 500

    Points: 526

    Thanks for the kind words!

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

    Thomas,

    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.

  • SQLRockstar

    SSCertifiable

    Points: 5960

    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.

    ----------------------
    https://thomaslarock.com

  • swellguy

    Mr or Mrs. 500

    Points: 526

    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,

    Brad

  • tferguson

    SSC Veteran

    Points: 232

    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.

    Tim

  • swellguy

    Mr or Mrs. 500

    Points: 526

    Appreciate the positive feedback, Tim.

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

  • Vertigo44

    Hall of Fame

    Points: 3991

    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?

  • Grant Fritchey

    SSC Guru

    Points: 395449

    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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Todd Robinson

    Grasshopper

    Points: 20

    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.

  • swellguy

    Mr or Mrs. 500

    Points: 526

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

    Thanks for reading my article,

    Brad

  • sqlrob

    Mr or Mrs. 500

    Points: 597

    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 13 (of 13 total)

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