The SLG Tier Hints Report - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Teradata Workload Analyzer
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The SLG Tier Hints Report

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 TWA 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 “Figure 1: Existing Workload Analysis Rules” on page 168 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 “Chapter 5 Analyzing Existing Workloads to Meet SLGs” on page 113.

Figure 1: Existing Workload Analysis Rules

To generate an SLG Tier Hints Report

✔ In the Existing workload Candidates Workload Report, right-click a workload and select SLG tier hints Report to generate the recommendations as shown below.

The SLG Tier Workload Method Hints Report appears.

Figure 2: SLG Tier Workload Method Hints Report



Workload Name

Displays the name of the current workload being viewed

Enforcement Priority

Displays the currently assigned enforcement priority for the selected workload

Relative Weight %

Displays the relative weight associated with the workload

Peak CPU %

Displays percent of Total CPU Percentage of the total CPU time (in seconds) used on all AMPs by this session

SLG (Response Time)

Displays SLG Changes Response Time

Recommendation for SLG Tier

Displays recommendation for SLG tiers (YES/NO)

Recommended SLG Tier Share

Displays recommended Share Percentage of SLG tier