The SLG Tier Hints Report - 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 TASM PreMigration tool helps customers to migrate an existing workload to Tactical and TimeShare methods based on enforcement priority and relative weights.

The SLG Tier method is intended for workloads that are associated with a short service level goal or service level expectation, which do not generally consume large amounts of CPU, and whose response time consistency is critical to the business.

The PreMigration recommendation on SLG Tier mapping is based on enforcement priority and workload classification, which may not be correct for many customers. PreMigration does not provide any recommendation for SLG Tier workload method percent share. This complicates SLES11 TASM migration.

Many customers find it difficult to assign the workloads to the SLG Tier method with an appropriate percent share. TWA bypasses this difficulty by providing the option to analyze the existing workloads based on DBQL data, and in this way provides the recommendations for workload reconfiguration.

This Teradata WA feature analyzes the existing workloads and provides the recommendations for SLG Tier migration based on peak CPU time and workload relative weight.

The Existing Workload Analysis feature analyzes the DBQL data based on the rules shown in the following figure and provides the recommendations for the SLG Tier workload management method and the workload percent share. For more information on using Existing Workload Analysis, see Overview.

Existing Workload Analysis Rules