System Health Metrics for Teradata Database

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
Metric Description
Active Sessions Number of sessions with active queries
AMP CPU Skew Comparison of CPU use on the busiest AMP to the average AMP
AMP I/O Skew Comparison of disk use on the busiest AMP to the average AMP
AMP Worker Tasks Average number of AMP worker tasks in use on each AMP
Component Down Number of components, such as BYNETs or AMPs, that are down
(CPU) System Average percentage of CPU time spent in system (kernel) mode
(CPU) User Average percentage of CPU time spent in user mode
CPU Utilization Average node CPU use. CPU is calculated as the sum of the user CPU, system CPU, and wait I/O usage percentages, depending on which of these are enabled by the Teradata Viewpoint Administrator in the Monitored Systems portlet
(CPU) Wait I/O Average percentage of CPU time spent waiting for I/O
DBC Disk Space Available DBC disk space in use
Max Disk by AMP Available disk space currently in use
Max Spool by AMP Available spool space in use
Memory Used Largest amount of memory used by a single node in kilobytes
Node CPU Skew Comparison of CPU use on the busiest node to the average node
Node I/O Skew Comparison of disk use on the busiest node to the average node
System Heartbeat Canary query showing the response time of the most recent system heartbeat in milliseconds
Total Disk Space Percentage of total disk space currently in use
Additional Canaries Additional canary queries that are defined for the system and used as part of the monitoring of system health