Weekly and/or Daily Reports
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.
Below are examples of some of weekly reports and their sources:
This report provides data on the relationship between resources and demand
This report provides data on how much demand there is.
This report provides data on the general responsiveness of the system.
This report provides data on how fast individual queries were responded to.
This report provides data on how many users and queries were active and concurrent.
This report provides data on how data volume is or is not growing.
This report provides data on how spool usage is or is not growing.
Note: The above reports can, of course, be run daily.