Database Suspect Data Page Event Class
This event is issued asynchronously from the insertion of a corresponding row into the suspect_pages table. Therefore, a job listening on this event might not find the corresponding suspect_pages entry immediately.
When the Database Suspect Data Page event class is included in a trace the relative overhead is low. The overhead might be greater if the number of suspect pages increases, for example, if a disk drive is experiencing problems.
Data Column Name
ID of the database for which the suspect page event has been raised. This is the same as the database_id column of the suspect_pages table.
The type of the event is 213.
Sequence of event class in batch.
ID of the SQL Server task that encountered the suspect page.
Time that the event occurred.
ID of the database file that contains the suspect page. This is the same as the file_id column of the suspect_pages table.
ID of the suspect page in the file. This is the same as the page_id column of the suspect_pages table.
Type of error that was encountered . This value is the same as the event_type value for the page in the suspect_pages table.