SQL Server alerts 19-25 - importance

pma111
pma111 used Ask the Experts™
on
I have read from a few 'best practices' guides that every SQL Server administrator/DBA should configure their production instances to alert on any events with "severity levels 19 through 25". However, I am trying to grasp exactly what those events relate to, and translate that into something meaningful to senior management as to 'if you dont get alerts on these events - this could be the consequences... for those who do use SQL alerting, do you capture these events, and to be blunt "why"?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
19-25 are fatal errors that could impact the database and servers. So you should create alert for them. Also create an alert for 823-825

for more info check the below posts

https://sqlperformance.com/2015/04/sql-performance/dealing-with-high-severity-errors-in-sql-server
http://www.sqlservercentral.com/blogs/vinaythakur/2011/11/29/day-29-fatal-errors-823-824-825-832-os-error-23/

You can configure these alerts to send an email.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial