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.
- 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.