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