CPU Threshold Exceeded Event Class
The CPU Threshold Exceeded event class indicates that Resource Governor detects a query that exceeds the CPU threshold specified for REQUEST_MAX_CPU_TIME_SEC.
Note |
|---|
The detection interval for this event is five seconds. It is guaranteed that an event will be generated if a query exceeds the specified limit by at least five seconds. However, if a query exceeds the specified threshold by less than five seconds, its detection might be missed depending on the timing of the query and the time of last detection sweep. |
Data column name | Data type | Description | Column ID | Filterable |
|---|---|---|---|---|
CPU | int | CPU usage in milliseconds. | 18 | Yes |
EventClass | int | Type of event = 214. | 27 | No |
GroupID | int | Group ID where the violation occurred. | 66 | Yes |
OwnerID | int | SPID of the process that caused the violation. | 58 | Yes |
SPID | int | ID of the server process that fires this event. NoteThis can differ from the actual user SPID if a system thread validates CPU usage as a background task. | 12 | Yes |
StartTime | datetime | The time when this event fired. | 14 | Yes |
Note