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)

Concepts

Manage the suspect_pages Table (SQL Server)