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