Monitoring Tools

  • What are the best tools available for monitoring MSSQL and Oracle databases. Our end goal is to have something usable for DBA's to quickly troubleshoot problems with both Oracle and MSSQL. Another benefit would be to have this application display a dashboard for the rest of the IT department so they can quickly see database performance at a glance.

  • JeepHound (3/28/2013)


    What are the best tools available for monitoring MSSQL and Oracle databases. Our end goal is to have something usable for DBA's to quickly troubleshoot problems with both Oracle and MSSQL. Another benefit would be to have this application display a dashboard for the rest of the IT department so they can quickly see database performance at a glance.

    A good question to ask to a site sponsored by Redgate 😀 ..but their tools are pretty good

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • Most monitoring tools at my workplace is stuff we built ourselves. Part of that is due to budget / corporate approval constraints. Part of that is the need for things that not even third party tools can accurately report on.

    And sometimes it's just faster and easier to build it ourselves instead of wading through all the red tape.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • If you want monitoring on both SQL Server and Oracle, your choices are limited. Quest software (Dell?) has a tool that can do both. Confio has two tools that each do one. Other than that, I haven't had to monitor Oracle for a while, so I'm not sure of any others.

    By the way, I do work for Red Gate, just so disclosure is clear.

    "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

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

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