Monday, October 10, 2011

Setting SQL Server Alerts

Its mostly advised to alert on SQL severity levels 17 to 25.

Severity levels from 17 through 19 will require intervention from a DBA (although they’re not as critical as 20-25):
17 Insufficient Resources
18 Nonfatal Internal Error Detected
19 Error in Resource

These are serious errors that will mean SQL Server is no longer working
20 SQL Error in Current Process
21 SQL Fatal Error in Database dbid Processes
22 SQL Fatal Error Table Integrity Suspect
23 SQL Fatal Error: Database Integrity Suspect
24,25 Hardware Error

No comments:

Post a Comment