Existing Workload Analysis - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-10-13
dita:mapPath
awa1488824663126.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

When the actual response time characteristics are off by a specific percentage from the defined service level goals calculated at the time of workload creation, an “X” in the SLG Met column indicates that service level goals are not met. A percent variance displays for further analysis with a visual indication against the workload. The SLG Met value calculations are based on the actual workloads data logged in DBQLogtabl and TDWMSummaryLog tables after activation of the rule set.

SLG Met details display in the Candidate Workloads Report dialog box.
The following analyses can be done for workloads that have not met their service level goals:
  • Existing Workload Analysis – Further analyzing and refining of the workload by selecting analysis parameters and accepting the new recommended workload.
  • Recalculating the service level goals and applying the actual SLG values in a rule set.
  • Merging the workload and recalculating the SLG Met values.
  • Splitting the workload and adding or deleting classifications manually.