17.05 - ResCPUByAMP 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 ResCPUByAMP, the ResCPUByAMPOneNode, and the ResAmpCpuByGroup macros, output the following:

Column... Reports the percent of time AMPs were busy doing user...
Awt User Serv% service for the AMP Worker Task (Awt) partition.
Misc User Serv% service for miscellaneous (all other except Partition 0) AMP partitions.
Awt User Exec% execution within the AMP Worker Task (Awt) partition.
Misc User Exec% execution within miscellaneous (all other except Partition 0) AMP partitions.
Total User Serv% service work. This is the sum of the Awt User Serv%, the Misc User Serv%, and AMP Partition 0 user service%.
User service is the time that a CPU is busy executing kernel system calls or servicing I/O and timer hardware interrupts.
Total User Exec% execution work. This is the sum of the Awt User Exec%, Misc User Exec%, and AMP Partition 0 user execution.
User execution is the time a CPU is busy executing user execution code, which is the time spent in a user state on behalf of a process.
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 reports the number of CPUs (NCPUs).

The NodeID column only appears in the ResCPUByAMP report.

The GroupID column only appears in the ResAmpCPUByGroup report.

For more information on how to monitor busy AMP Worker Tasks, see “AWT Monitor (awtmon)” in Teradata Vantage™ - Database Utilities , B035-1102 .

ResCPUByAMP Examples

exec resCPUByAMP(,,,,,);

exec resCPUByAMPOneNode(,,,,);

exec resAmpCpuByGroup(,,,);