Trends View Metrics - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Workload metrics are displayed for each workload on the Trends view. Trend intervals and past averages are set in Settings, and metrics are enabled and disabled in Settings.
Metric Description Operating System
Active Queries Number of active queries SLES 10 and 11
Avg CPU-SEC per Query Average CPU time, in seconds, of all workload queries SLES 10 and 11
Average Physical KB I/O per Query Average physical I/O usage, in kilobytes, of all workload queries SLES 11
Average Response Time and Delay Time Average response time and delay time for all completed queries SLES 10 and 11
Cumulative CPU Cumulative CPU seconds per AMP SLES 10 and 11
Decayed Active Queries Total number of queries that have decayed due to CPU or I/O consumption (Timeshare workloads only) SLES 11
Delayed Queries Number of queries in the delay queue SLES 10 and 11
Deferred Queries Number of queries in deferred queue. SLES 11
Impact CPU-SEC Maximum amount of CPU time used by a workload compared to the total CPU used by all workloads on the system SLES 10 and 11
Max CPU-SEC per Query Maximum CPU time, in seconds, of all queries that completed SLES 10 and 11
Maximum Physical KB I/O per Query Maximum physical I/O usage, in kilobytes, for all queries in this workload SLES 11
Maximum Response Time Longest response time of all requests that completed SLES 10 and 11
Tactical Queries with Exceptions Total number of queries reassigned to another workload due to CPU or I/O per node tactical exception (Tactical workloads only) SLES 11
Throughput Number of queries arriving and completing every minute SLES 10 and 11