Workloads Metrics for Teradata System - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
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