Canary Response Times View | Teradata Viewpoint - Canary Response Times View - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem

The Canary Response Times portlet monitors the workload of a single Teradata system over time. You can monitor the performance of multiple systems by adding a Canary Response Times portlet instance for each Teradata system you want to monitor. The Export button allows you to create a .csv file containing selected data.

The summary view shows current and historical performance data using sparklines. The sparkline is a horizontal graph, showing the time (in milliseconds) a query takes to complete. Canary response times, such as System Heartbeat, are represented by a data point that is added to the sparkline once every 60 seconds. Hover over a sparkline to see an information balloon containing detailed information about the data point.

The sparkline types are:
Current Data
Shows the time (in milliseconds) that a query takes to complete. Each data point shown on the sparkline is the average of all response times recorded during a 120-second interval, by default. The result is a curve sparkline. A large dot at the NOW point on the sparkline indicates the value of the last data point captured. A number to the right of the sparklines also indicates the NOW data-point value.

The Teradata Viewpoint Administrator sets the default data collection rate.

Past Average
Presents the averages for a user-selected number of weeks. The sparkline is shown as a skyline chart with flat, solid data points. Use this sparkline to compare the current performance from the previous 60-minute or 120-minute period with the system performance during the same 60-minute or 120-minute period 1 or more weeks in the past. Use the past-average data shown from NOW to 30 minutes or 60 minutes in the future to estimate system workload and enhance decision-making regarding workload assignments and resource allocation.

Canary response time-past average
A 90-minute period is shown in the minimized view and a 180-minute period is shown in the maximized view. You can change these views from "".
Minimized
The skyline shows 90 minutes of the average-workload data values from a user-selected number of weeks in the past. The curve sparkline shows the actual data for the past 60 minutes using 1-minute data points.
Maximized
The skyline shows 180 minutes of the average-workload data values from a user-selected number of weeks in the past. The curve sparkline shows the actual data for the past 120 minutes using 1-minute data points.