17.10 - Canary Response Times Overview - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)

The Canary Response Times portlet allows you to analyze trends in single-system performance over a 60-minute or a 120-minute period using canary queries. Canary queries measure the time in milliseconds it takes for a user-defined query to run to completion. The same query is run repeatedly at a preselected interval to compare system workload over time. The longer the query takes to complete, the heavier the system workload at that time.

Canary response times can help you plan maintenance activities or schedule your workloads appropriately. For example, you can use this portlet to identify heavy workload periods on a Teradata Database system so that you can avoid assigning tasks when system performance is marginal. You can also use canary response times to compare current performance with average performance measured across one or more weeks of historical data. Additionally, you can monitor and compare the performance of multiple Teradata Database systems by adding a Canary Response Times portlet to the portal page for each monitored system.

The summary view displays a graphic overview of selected canary query metrics monitored over the previous 60-minute or 120-minute period. Samples are taken once every minute, and a data point is added to the graph for each selected canary query metric.

The Teradata Viewpoint Administrator defines default metrics for the Canary Response Times portlet in the Monitored Systems portlet. If enabled for your profile, you can set metrics that override the defaults.

The Canary Response Times portlet also gives you a means for comparing current and historical data by displaying past performance as an average of metric data points collected over time. The duration over which the averages are calculated can be changed using the Past Averages tab.