Trends View Metrics

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
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