ResCPUByPE Macros Output - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
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 plus PE Partition 0 user service.
Total User Exec% execution work. This is the sum of the four user execution columns 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.
These 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(,,,);