Top SQL DBA Tools

  • Which company's have the best SQL Administrator tools? RedGate, SolarWinds DPA or Idera ?

  • There is some crossover between products across those companies, but also you should note that each company also offers some unique tools not offered by the others. Be sure what you need before you evaluate just based on a given organization's offerings.

    Unfortunately, my point of view is more than a little biased, so I won't comment beyond this point.

    "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

  • As Grant said, find out what you need to monitor. Then when you have a 14 day trail you know what to test. By the way if you get to the end of your 14 days but have not decided, call the company and they my extend your trial.

  • don't forget, it's not just monitoring. There are backup products, deployment, source control, compare, all sorts of tools. Be sure you explore the full offering and, again, understand what it is you need.

    Also, just a suggestion, if all you're looking at is monitoring tools, you should add SQL Sentry [/url]to that list.

    "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

  • Heh... at best, all of those tools are only second best to the most important administrative tool of them all... the brain of the DBA. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 5 (of 5 total)

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