Productivity View | Teradata Viewpoint - Productivity View - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

The Productivity view displays a high-level overview of the performance trends for a Teradata Database system during the preceding 24 hours or 48 hours. The Export button allows you to create a .csv file containing selected data.

Data trends are represented in a horizontal graph called a sparkline. Hover over a sparkline to see an information balloon containing detailed information about the data point. The sparkline types are:
Canary Response Times
Canary-response-time metrics show the time (in milliseconds) a query takes to complete. Canary response times, such as System Heartbeat are represented by a curve sparkline. Every 15 minutes, a new data point is added to the sparkline, representing the average canary response time recorded during the interval. A large dot and a number at the end of the sparkline indicate the last data point captured.
Queries Per Hour
Queries-per-hour (QPH) metrics show the number of queries against the database for each hour over the 24-hour or 48-hour period for the selected metric. For example, the TOTAL QPH sparkline is a skyline sparkline, used to represent QPH metrics. A flat, solid data point represents the number of queries per hour on the timeline.
System Health
The System Health metric provides an overview of the worst state of the monitored system, sampled at 15-minute intervals during the 24-hour or 48-hour period. System Health is represented by a bar sparkline and uses default or custom states and tooltips. The values on the sparkline represent the worst system state experienced during each 15-minute period.

A 24-hour period is shown in the minimized view and a 48-hour period is shown in the maximized view. You can change these views from.



To display data in the Productivity view, the Teradata Viewpoint Administrator must first enable the Query Count, System Stats, and Canary Queries collectors. The Teradata Viewpoint Administrator also specifies the data collection rate for each collector.

Factors external to Teradata Viewpoint can also affect the collection and display of data. The Teradata System Administrator must enable query logging on the Teradata Database system.