16.20.16.20 - 16.20 - Today's Statistics View Metrics - Teradata Workload Management

Teradata® Viewpoint User Guide

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

Information about available metrics is provided in the tables. Use the Metrics tab in the Settings view to select metrics for display in the Today's Statistics view.

The Teradata Viewpoint Administrator must enable the appropriate collectors to calculate and display statistical data in the Today's Statistics view. When the Canary Queries Collector is the source for a metric, the data displayed is always the heartbeat query for the selected system.

System Metrics

The System Stats collector gathers system metrics. System metrics are calculated as an average.
Metric Description Type
Active Sessions Sessions with active queries Number
AMP CPU Skew Comparison of CPU use on the busiest AMP to the average AMP Percent
AMP I/O Skew Comparison of disk use on the busiest AMP to the average AMP Percent
AWT Average AMP worker tasks (AWTs) in use on each AMP Number
CPU Average node CPU use. CPU is calculated as the sum of the user CPU and system CPU usage percentages. Percent
System CPU Average CPU time spent in system mode Percent
Total Disk Space Total disk space currently in use Number
User CPU Average CPU time spent in user mode Percent
Wait I/O CPU Average CPU time spent waiting for I/O Percent

Query Metrics

The Query Count collector gathers query metrics.
Metric Description Type
Concurrency Average number of queries executing simultaneously during the hour Number
First Response Time Avg Average time in milliseconds it takes to receive the first response Number
First Response Time Max Maximum time in milliseconds it takes to receive the first response Number
First Response Time Min Minimum time in milliseconds it takes to receive the first response Number
First Response Time Stddev Standard deviation time in milliseconds it takes to receive the first response Number
Query Count Queries logged in dbc.QryLog, or the sum of Querycount from dbc.QryLogsummary during the sample period Number
Spool Usage Avg Average amount of spool in bytes the query used Number
Spool Usage Max Maximum amount of spool in bytes the query used Number
Spool Usage Min Minimum amount of spool in bytes the query used Number
Spool Usage Stddev Standard deviation of amount of spool in bytes the query used Number

Performance Metrics

The Canary Queries collector gathers performance metrics. Performance metrics are calculated as an average.
Metric Description Type
Response Time Average response time in milliseconds of the selected canary query Number
Rows Returned Average number of rows returned by the selected canary query Number