Workloads Metrics for Teradata Database - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Workload metric descriptions for the trends sparkline graphs shown in the Workloads details view are listed below.
Metric Description Operating System
Avg CPU-SEC per Query Average CPU time, in seconds, of all workload queries SLES 10 and 11
Max CPU-SEC per Query Maximum CPU time, in seconds, of all queries that completed SLES 10 and 11
Cumulative CPU Cumulative CPU seconds per AMP SLES 10
Average Physical KB I/O per Query Average physical I/O usage, in kilobytes, of all workload queries SLES 11
Throughput Number of queries arriving and completing every minute SLES 10 and 11
Active Queries Number of active queries SLES 10 and 11
Delayed Queries Number of queries in the delay queue SLES 10 and 11
Average Response Time & Delay Time Average response time and delay time for all completed queries SLES 10 and 11
Maximum Response Time Longest response time of all requests that completed SLES 10 and 11