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]

Sources:

Last modified: April 21, 2020

Author

Comments

Write a Reply or Comment