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