SQL Server will log the following I/O-related events in its error log:
-
823: A read or write failed.
-
824: A page was successfully read from disk, but there is something wrong with the page.
-
825: A page was successfully read from disk, but the initial read request failed.
SQL Server Agent alerts can be configured to monitor for these errors (and other high-severity errors), which can provide early notification that there may be issues related to the disk subsystem that houses the OnBase database files.
Create SQL jobs to send alerts if 823, 824, or 825 errors are reported by SQL Server.
Please refer to Microsoft SQL Server Books Online for more details on these errors and for information on the configuration of SQL Server Agent alerts.