17.05 - ResCPUByPE Macros Output - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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(,,,);