| title | CPU Threshold Exceeded Event Class | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | conceptual | |
| topic_type |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | eb106f7d-baa3-4a2b-96b2-f9fe0844057d | |
| author | stevestein | |
| ms.author | sstein | |
| manager | craigg |
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 |
214 | 27 | No |
| EventSubClass | int |
CPU limit violation. | 21 | Yes |
| 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. Note: This 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 |