Weekly and/or Daily Reports | Teradata Vantage - Weekly and/or Daily Reports - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

Weekly reports provide data on performance trends.

To make weekly and/or daily reporting effective, Teradata recommends that you establish threshold limits. Note that filtering on key windows having a 24-hour aggregate of weekly aggregates that includes low-used weekends and night hours distorts the report.

Furthermore, Teradata recommends that you analyze the longest period possible. This avoids misleading trend data by softening temporary highs and lows.

Examples of some weekly reports and their sources include:
  • CPU AV & Max from ResUsage

    This report provides data on the relationship between resources and demand.

  • CPU seconds by workload (account) from AMPUsage.
  • Throughput by Workload from DBQL

    This report provides data on how much demand there is.

  • General Response times from Heartbeat Query Log

    This report provides data on the general responsiveness of the system.

  • Response Time by Workload from DBQL

    This report provides data on how fast individual queries were responded to.

  • Active Query & Session Counts by Workload

    This report provides data on how many users and queries were active and concurrent.

  • CurrentPERM

    This report provides data on how data volume is or is not growing.

  • Spool

    This report provides data on how spool usage is or is not growing.

These reports can, of course, be run daily.