Workloads Metrics for Teradata Database - 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 metric descriptions for the trends sparkline graphs shown in the Workloads details view are listed as following.

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