Post reply

Request for advice on performance monitoring software

  • September 15, 2008 at 1:34 pm

    #198157

    Hi,

    Does anyone have any suggestions or advice on the following products for monitoring SQL Servers for performance, stability, drive space, etc.?

    Spotlight for SQL Server Enterprise

    idera SQL Server diagnostic manager

    Microsoft System Center Operations Manager

    If there are others that are worth considering, I'd be grateful if you could post them as well.

    Thanks for any help!

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • September 15, 2008 at 5:13 pm

    #872082

    These days I use Performance Dashboard and my own home-grown scripts for monitoring (they're free and portable). However, I've used Idera's Diagnostic Manager in the past with great success.

  • September 15, 2008 at 8:26 pm

    #872102

    Pam Brisjar (9/15/2008)

    These days I use Performance Dashboard and my own home-grown scripts for monitoring (they're free and portable). However, I've used Idera's Diagnostic Manager in the past with great success.

    Thanks for the feedback. Are there any sites or links that show approximate price comparisons for the not-free tools?

    Thanks again,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • September 15, 2008 at 8:35 pm

    #872104

    Are there any sites or links that show approximate price comparisons for the not-free tools?

    Thanks again,

    webrunner

    I think SQL Server magazine has done some ratings of various tools.

    Just call them up and get quotes and get the demo versions so you can test them out yourself. Idera often discounts their list price, so I wouldn't trust some 3rd party to give you good pricing info.

  • September 16, 2008 at 1:06 am

    #872162

    Ten Centuries,

    Better to script it yourself.

    By scripting it yourself you will get familiar with the sys-tables and you can extract just what you need.

    Store it in a specially designed tablestructure and report counters either by select-to-file, e-mail or using Reporting Service (MS).

    Create a method to "crawl" other servers as well using the LinkedServers mechanism and store the data in a local database a seperate server especially for this purpose (not to interfear with other load on any server).

    Keep it light with as less overhead as possible (especially on heavy used server).

    Better not install deamons or gathering databases on productie environments.

    Mention agreements on security and processes within you company

    Mention default settings such as sp_cmdshell / sp_OAxxxx procedures etc.

    Need more info. . .contact me (cause I've written such a DB-monitor environment).

    GKramer

    The Netherlands

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

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