Today's Statistics View - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

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

The Today's Statistics view displays a statistical analysis of system-resource use over a user-defined time period. A table lists the monitored metrics and compares current statistics to statistics from the same time period 1 or more weeks in the past. Metrics are grouped into categories so that metric data collected at the same frequency is displayed together in the view. The view is refreshed every 2 minutes.

Table columns provide the following information:
STATISTIC
The name of the monitored metric.
LAST X HOUR(S)
The value of the metric from a user-specified number of hours ago, up to 999 hours in the past, until the current time.
SAME PERIOD X WEEK(S) AGO
The value of the metric over the same time period as LAST X HOUR(S), up to 999 weeks in the past.
SINCE X AM/PM TODAY/YESTERDAY
The value of the metric calculated from a user-specified hour of the day, either today or yesterday, until the current time.
SAME PERIOD X WEEK(S) AGO
The value of the metric over the same time period as SINCE X AM/PM TODAY/YESTERDAY, up to 999 weeks in the past.


To display statistical data in the Today's Statistics view, the Teradata Viewpoint Administrator must first enable the Query Count, System Stats, and Canary Queries data collectors. The Teradata Viewpoint Administrator also specifies the data collection rate for each collector.

Factors external to Teradata Viewpoint can also affect the collection and display of statistical data:
  • Query Logging. The Teradata System Administrator must enable query logging on the Teradata Database system.
  • Data Collection. Query data must have been collected during all time periods selected on the Sampling Interval tab in the Settings view. Teradata Viewpoint collectors and query logging must have been enabled during all selected time periods in order for Today's Statistics data to display correctly.

Use the Settings view to select the system and metrics category to monitor, set metrics thresholds, and set the sampling interval. The column headings depend on the selections made in the Settings view and how frequently data for each metric is collected. For example, the heading LAST 2 HOURS appears when the sampling interval is 2 hours and data for the previous 2 hours is available.