Process Scheduling: CPU Utilization Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantage™

These columns represent CPU activities associated with this virtual processor, subdivided into 48 partitions. Partition 0 is reserved for use by PDE processes. For more information on the other partitions see Partition Assignments Overview.

For definitions of user service and user execution, see “Process Scheduling Columns” in the ResUsageScpu Table Overview.

Column Name Mode Description Data Type
CPUUServPart00 -CPUUServPart48 count Time in centiseconds CPUs are busy in the partition doing user service. This is the system level time spent on a process. FLOAT
CPUUExecPart00 -CPUUExecPart48 count Time in centiseconds CPUs are busy in the partition doing user execution. This is the user level time spent on a process.
Some CPU times may not be reported to these fields if child processes or threads are running on your system. For information about the difference in CPU usage reported and possible cause, see Process Scheduling: CPU Utilization Columns in ResUsageSps table.
FLOAT