Post reply

SQL Alerts

  • July 5, 2010 at 3:08 am

    #145845

    Hi all

    I am just wondering if anyone could point me to a list of common alerts to setup when monitoring my SQL 2005 Servers, such that I can perhaps standardise their configuration. There are many it seems I could configure but was wondering if there is a common list most people employ?

    Thanks

  • July 5, 2010 at 5:54 pm

    #1188912

    If you are talking about the database level, well that is up to yourself, but generally all job failures, and database status should be monitored. I would also alert for alot of login failures, cpu, memory and disk utilisation. It depends on how much time you have and how critical the servers are

  • July 5, 2010 at 11:18 pm

    #1188924

    You can also use database mail

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • July 7, 2010 at 4:28 am

    #1189512

    I create alerts for error severities 17 thru 25; we also use Quest's Big Brother for host monitoring.

  • July 7, 2010 at 4:46 am

    #1189518

    Hi,

    The most important are Sev.17,19,21 through 25

    Thanks

    John

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

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