suspect pages

Pages in an SQL database that are torn or suspect are accomulated in a table and can be queried with

SELECT * FROM [msdb].[dbo].[suspect_pages]

Columns are database_id,  file_id,  page_id,  event_type,  error_count, and  last_update_date

Consider Select count(*) …  to get an overview.  

When SQL Server tries to read a page into memory (during a query, following DBCC checkDB operation or a backup) and can’t, it issues a 823 or 824 error.  It probably gets logged (?) but should also be posted to the suspect_pages table in MSDB.  

This is well-documented in http://technet.microsoft.com/en-us/library/ms191301(v=sql.105).aspx and https://www.simple-talk.com/blogs/2013/07/15/keeping-an-eye-on-your-storage/

Advertisements