Users View Metrics - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Metrics available for display are listed below.
Metric Description
Burn rate Percentage of the overall system capacity that was effectively consumed by this query during its execution
Gating efficiency Percentage of the overall system capacity that was effectively consumed by all queries during their execution. A value of 100 indicates all time was spent executing.
Impact CPU Impact of jobs on the system taking CPU skew into account. The value is equal to the highest CPU time in seconds consumed by any one AMP on behalf of a job or query multiplied by the number of AMPs.
Max spool Total amount of temporary spool space used
Query counts Total number of executed queries
Suspect Queries Number of queries designated as suspect based on thresholds set in the Query Log data collector
System Utilization Percentage of the system's CPU utilized by the user or application
Time active Amount of time in seconds the query or job spent executing. Excludes any time the query or job was delayed before being executed.
Time delay Amount of time in seconds the query or job was delayed before being executed
Time Expansion Ratio of how long the query took to execute versus how long it could have ideally run. The larger the number, the more the execution time of the query was expanded. For example, a value of 10x to indicates an expansion of 10 times the ideal execution time.
Total AMP CPU Total amount of CPU consumed by AMPs in processing queries
Total I/O Total number of I/O requests
Total parser CPU Total amount of CPU consumed by the parsing engine in processing queries
Username Name of the user who submitted the query