Enhancing the Existing Workload Analysis Process - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following suggestions may help Teradata WA enhance the processing speed and accuracy of the existing workload analysis process:

  • Select the appropriate DBQL log data for analysis (activated rule set data).
  • Verify that the TDWM database has sufficient spool space to create temporary tables for analysis and service level goal calculations. Sufficient spool space is a primary requirement for better performance during the calculation of service level goals and workload refinement. If there is inadequate spool space, Teradata WA displays an error message and service level goal calculation continues on actual DBQL tables, using multi-threading.