16.20.16.20 - 16.20 - Canary Response Times View - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

The Canary Response Times portlet monitors the workload of a single Teradata Database system over time. You can monitor the performance of multiple systems by adding a Canary Response Times portlet instance for each Teradata Database 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.


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.