Database Suspect Data Page Event Class

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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

sp_trace_setevent (Transact-SQL)
Manage the suspect_pages Table (SQL Server)