ResCPUByPE Macros Output - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

The reports generated by the ResCPUByPE, ResCPUByPEOneNode, and ResPeCPUByGroup macros, output the following:

Column... Reports the percent of time PEs are busy doing user...
Disp User Serv% service for the Dispatcher partition of the PE.
Ses User Serv% service for the Session Control partition of the PE.
Misc User Serv% service for miscellaneous (all other, except Partition 0) PE partitions.
Disp User Exec% execution within the Dispatcher partition of the PE.
Ses User Exec% execution within the Session Control partition of the PE.
Misc User Exec% execution within miscellaneous (all other, except Partition 0) PE partitions.
Total User Serv% service work. This is the sum of the four user service columns above plus PE Partition 0 user service.
Total User Exec% execution work. This is the sum of the four user execution columns above plus PE Partition 0 user execution.
Total Busy% service and execution work. This is the sum of the Total User Serv% and the Total User Exec% columns.
The above CPU statistics represent the aggregate of all time spent in the indicated way by all CPUs on the node. Because there are multiple CPUs, the Total Busy % should be compared to a theoretical maximum of 100% times the number of CPUs on the node.

The Node CPU column in the following sample outputs reports the number of CPUs (NCPUs).

The NodeID column only appears in the ResCPUByPE output report.

The GroupID column only appears in the ResPeCpuByGroup output report.

ResCPUByPE Examples

exec resCPUByPE(,,,,,);

exec resCPUByPEOneNode(,,,,);

exec resPeCpuByGroup(,,,);