Post reply

monitoring tools for DBA

  • July 21, 2011 at 1:46 am

    #145796

    Hi,

    Please suggest monitoring tools Basically, I want to be able to monitor the servers, whether it be resources, disk space, job running status, etc.

    our Production server are 2 different Network how to configure the Monitoring tools for the Both n/w

    our main purpose is

    Scheduled backups jobs monitoring status(success/failures)

    Agent Jobs status

    Db status(healthy)

    CPU utilization

    top 10 Long running Queries status

    Please reply soon

  • July 21, 2011 at 3:01 am

    #1356218

    Hi James

    You can get some information from Activity Monitor within SQL 2008.

    As for 3rd party tools we use SQL Sentry. We did test a few at the time.

    This monitors CPU, Memory, Waits,Disk IO, disk space etc along with currently running statements and historical statements run (along with query plans). Also monitors blocking and deadlocks.

    We find it very useful!!

  • July 21, 2011 at 4:51 am

    #1356253

    I'd suggest you download a copy of SQL Monitor[/url] from Red Gate software. Based on the list of monitoring needs you think you have I think it might be a good fit.

    You can also see SQL Monitor in action monitoring the SQL Server Central databases live by going here.

    Full disclosure: I'm a Red Gate employee.

    "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

  • July 21, 2011 at 6:15 am

    #1356283

    If you are not going to monitor constantly, you can use Microsoft.com/MAP, at the moent they are in version 6. It is a very handy tool.



    My blog

  • July 21, 2011 at 6:16 am

    #1356286

    Grant Fritchey (7/21/2011)

    I'd suggest you download a copy of SQL Monitor[/url] from Red Gate software. Based on the list of monitoring needs you think you have I think it might be a good fit.

    You can also see SQL Monitor in action monitoring the SQL Server Central databases live by going here.

    Full disclosure: I'm a Red Gate employee.

    I use SCOM at the moment, but I'm sure SQL Monitor will be better.



    My blog

  • July 26, 2011 at 12:21 am

    #1358251

    Try SQL Stripes - it does exactly what you're looking for.

    [font="Arial"]www.sqlstripes.com[/font]

  • July 26, 2011 at 5:44 am

    #1358391

    Or write your own ... jobs that run check procs & output to central db or powershell / dos cms that call procs you've written to check.

Viewing 7 posts - 1 through 6 (of 6 total)

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