TechNet
Export (0) Print
Expand All

CPU Threshold Exceeded Event Class

 

Applies To: SQL Server 2016

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.

System_CAPS_ICON_note.jpg 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 nameData typeDescriptionColumn IDFilterable
CPUintCPU usage in milliseconds.18Yes
EventClassint21427No
EventSubClassintCPU limit violation.21Yes
GroupIDintGroup ID where the violation occurred.66Yes
OwnerIDintSPID of the process that caused the violation.58Yes
SPIDintID 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.
12Yes
StartTimedatetimeThe time when this event fired.14Yes

sp_trace_setevent (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft