Normalized Viewing of CPU Usage by PE - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantage™

Some users may prefer to view CPU usage by PEs in a normalized fashion. Conceptually, this restates each of the above statistics in terms of percentage of total CPU capacity of the node.

The following SQL example shows how to perform this normalization for the Total Busy % statistic.

SEL TheDate, TheTime,Vproc,NodeID,
(PETotalUserExec+PETotalUserServ)
/Secs/NCPUs
(FORMAT ‘zz9%’,TITLE ‘Total// Busy// %’)
FROM ResCpuUsageByPEView
WHERE TheDate = CURRENT_DATE AND TheTime>080000
ORDER BY 1,2,3;