Enhance the Existing Workload Analysis Process - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
sef1527114222310.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
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.