Admin Tool

  • Hi

    Can anybody suggest a product that can monitor multiple sql 2005 servers giving graphical interface reporting on disk space, performance, logins and a host of other tolls that would be useful, we also have a couple of sql 2008 servers, so product that could report on both versions would be useful.

    🙂

  • Hi,

    There are numerous tools out there... a quick google search will enlighten you! This topic has also been discussed within these very forums.

    Redgate's SQL Monitor is one as well as the more expensive Quest Spotlight you could also use Microsofts SCOM product but you would need to adapt the SQL management pack to match your requirements.

    Cheers,

    Mark

  • There is performance dashboard reports which is an add-on utility. You could try this for identifying performance related issues.

    M&M

  • Most of the software out there allows you to download it and try it out. Each one offers different sets of details and has some different monitoring mechanisms. I'd suggest trying them in a test on your environment.

    "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

  • idear 's sql diagnostic manager

    http://www.idera.com/Products/SQL-Server/SQL-diagnostic-manager/

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

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

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