These alerts are focussed on successful access(IO) to the hard drives that SQL Server is using. If there are any errors when reading or writing to the drives then one of these errors will be returned. Having the alerts on these errors means that any IO issues will be brought to the DBAs attention well before a disk actually fails.
SELECT m.[message_id] ,
m.[severity] ,
m.[is_event_logged]
FROM sys.messages AS m
WHERE language_id = 1033
AND m.[message_id] IN ( 823, 824, 825 )
AND is_event_logged = 1
ORDER BY severity ,
m.[message_id]
Comments