Trends View Metrics - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.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
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