Database Suspect Data Page Event Class
The Database Suspect Data Page event class indicates when a page is added to the suspect_pages table in msdb. Include this event class in traces that are monitoring the occurrence of suspect pages.
Note
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.
Database Suspect Data Page Event Class Data Columns
Data Column Name |
Data Type |
Description |
Column ID |
Filterable |
|---|---|---|---|---|
DatabaseID |
int |
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. |
3 |
Yes |
EventClass |
int |
The type of the event is 213. |
27 |
No |
EventSequence |
int |
Sequence of event class in batch. |
51 |
No |
SPID |
int |
ID of the SQL Server task that encountered the suspect page. |
12 |
Yes |
StartTime |
datetime |
Time that the event occurred. |
14 |
Yes |
ObjectID |
int |
ID of the database file that contains the suspect page. This is the same as the file_id column of the suspect_pages table. |
22 |
Yes |
ObjectID2 |
int |
ID of the suspect page in the file. This is the same as the page_id column of the suspect_pages table. |
56 |
Yes |
Error |
int |
Type of error that was encountered . This value is the same as the event_type value for the page in the suspect_pages table. |
31 |
Yes |
See Also
Reference
sp_trace_setevent (Transact-SQL)