16.20.16.20 - 16.20 - Workloads Metrics for Teradata Database - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

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