15.10 - Enhancing the Existing Workload Analysis Process - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

prodname
Teradata Workload Analyzer
vrm_release
15.10
category
User Guide
featnum
B035-2514-035K

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.