17.10 - Workloads Metrics for Teradata Database - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-2206-101K
Language
English (United States)

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