Canary Response Times - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

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.