Process Scheduling Columns | ResUsageSps Table | Teradata Vantage - 17.05 - Process Scheduling: CPU Utilization Columns - 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

These columns represent CPU activities on the node associated with the AMP Worker Task, Dispatcher, Parser, or miscellaneous activities.

When an external routine (such as C, C++, Java UDF, or external stored procedure) forks a child process or thread, the CPU time is not reported to these fields. As a result, the resource usage table shows a lower CPU usage than shown in the ResUsageSpma table even if the external routine consumes a large amount of CPU time. If there are child processes or threads running on your system, this may account for the larger CPU times reported in the ResUsageSpma table compared to this table. To confirm that the difference in CPU usage reported by the ResUsageSpma table is caused by child processes or threads, contact your Teradata Support Center personnel.
Column Name Mode Description Data Type
CPUUServ count CPU time in milliseconds spent by AMP Worker Task or Dispatcher/Parser executing user service code. If VprType is AMP, the field contains the system-level AMP worker task CPU usage. If VprType is PE, the field contains the system-level Dispatcher/Parser CPU usage. FLOAT
CPUUServOther count Time in milliseconds CPUs are busy executing miscellaneous activities for user service code. This is the system-level time spent on a process. FLOAT
CPUUExec count CPU time in milliseconds spent by AMP Worker Task or Dispatcher/Parser executing user execution code. If VprType is AMP, the field contains the user-level AMP worker task CPU usage. If VprType is PE, the field contains the user-level Dispatcher/Parser CPU usage. FLOAT
CPUUExecOther count Time in milliseconds CPUs are busy executing miscellaneous activities for user execution code. This is the user-level time spent on a process. FLOAT