Today's Statistics 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 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.

Viewpoint Today's Statistics view

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