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 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 .
exec resCPUByAMP(,,,,,); exec resCPUByAMPOneNode(,,,,); exec resAmpCpuByGroup(,,,);