Skip to content

Best Practice: SQL Server Failure Alerts & Notifications

by on June 5, 2014

SQL Server Failure Alerts & Notifications

You should monitor and be alerted for severity levels 17 to 25. Level 14 is optional, as are other levels, but some organizations prefer to monitor login (14) issues, this can help catch malicious access.

clip_image002

NOTES And Prerequisites:

  1. Set up and test Management > Database Mail before alerts are created
  2. Set up an Operator (often Help Desk or DBA) before alerts are created
  3. Consider creating Job Alerts as part of your Best Practices

Low Priority

Description: Non-serious errors. Often is considered user correctable.

Severity Level 014: Insufficient Permissions – Low

Medium Priority

Description: Severity levels from 17 through 19 will require intervention from a DBA, they’re not as serious as 20-25 but the DBA needs to be alerted.

Severity Level 017: Insufficient Resources – Medium

Severity Level 018: Nonfatal Internal Error – Medium

Severity Level 019: Error In Resources – Medium

High Priority

Description: Severity Levels 20 through 25 are serious errors that mean SQL Server is no longer working, notify the DBA immediately.

Severity Level 020: Error In Current Process – High

Severity Level 021: Fatal Error In DB DBID Processes – High

Severity Level 022: Fatal Error Table Integrity Suspect – High

Severity Level 023: Fatal Error DB Integrity Suspect – High

Severity Level 024: Fatal Error Hardware – High

Severity Level 025: Fatal Error Hardware – High

How To Create an Alert In Microsoft SQL Server

  1. SQL Server Agent (expand) > right click Alerts > New Alert
  2. Set Name and severity level as above in each alert > General
  3. Notify Operators in each alert > Response > Notify Operators > select help desk or DBA
  4. Include Description in each alert > Options > additional notifications

Related:

Best Practice: Create Job Failure Notifications in SQL Server

Advertisements

From → Microsoft, SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: