Post reply

what alerts you use

  • June 14, 2008 at 2:21 am

    #129525

    Hi,

    can you share what alerts you use to monitor your SQL server from the SQL server Agent Alerts and Perfmon side?

    THX

  • June 17, 2008 at 8:08 pm

    #830157

    Hi,

    I usually set the same alerts initially on all of the servers:

    - for all errors with severity 19 and higher

    - database log file 90% or more full (have job running script to check files)

    - dead locks

    - userDB1 log file size is 5GB (just problem databases)

    - tempDB log file 1GB

    - filegroup is full

    - fixed File Size is close to MAX (have job running script to check files)

    - permissions error (severity 14)

    - log file is full

  • June 17, 2008 at 10:35 pm

    #830184

    We have alert for all the object (table, stored procedure, index, etc) changes.

  • August 15, 2008 at 7:06 am

    #858671

    Hi

    We have been looking for something like that...will it be possible to share your knowledge with us 🙂

    To be alerted when logs are full,or tempdb is full, etc....

    Thanks in advance

    A

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

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