SQL Server Alerts List

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  June 3, 2015 at 11:32 am

  #298722

  Hello Experts,

  In my SQL platform, I have created the below list of alerts:

  'CPU Utilization is High',

  'Database Creation',

  'Database Deletion',

  'Database Log is Full 9002',

  'Database Log is Not Available 9001',

  'Error',

  'Full msdb log',

  'Full tempdb',

  'Heavy Load Error',

  'I/O Error Detected 823',

  'Insufficient Resources',

  'ODBC Connection Failed',

  'ServerRestarting',

  'SettingOptions',

  'Sev. 14 Errors',

  'Sev. 16 Errors',

  'Sev. 17 Errors',

  'Sev. 18 Errors',

  'Sev. 19 Errors',

  'Sev. 20 Errors',

  'Sev. 21 Errors',

  'Sev. 22 Errors',

  'Sev. 23 Errors',

  'Sev. 24 Errors',

  'Sev. 25 Errors',

  'SQL Server Blocked Access',

  'SQLServer Failed Logins',

  'SSPI Handshake Failure',

  'Starting Up Database',

  'MemoryDegradation',

  'SpaceMonitor'

  Do you guys suggest creating few more alerts so that DBA can be notified to take action?

  I'm planning to add one more with message_id = 4060, i.e. cannot open database.

  Also, in my platform there are many servers with Biztalk and Sharepoint.

  Do you suggest adding few of them are useful and specific to Biztalk and Sharepoint?

  Thanks.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  June 5, 2015 at 3:26 pm

  #1803484

  Any update by anyone?

  Thanks.