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.