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 |