Редагувати

Поділитися через


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)