SLG Tier | Teradata Vantage - SLG Tier - Analytics Database - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
Teradata Vantage
Under the Tactical tier in the priority hierarchy, remaining resources flow down to the SLG tier. You can define up to 5 SLG tiers. Each workload in an SLG tier is assigned a percentage of tier resources to ensure that requests perform consistently and meet Service Level Goals. Unused resources flow down each of the SLG tiers with assigned workloads, in SLG tier order, and then on to the Timeshare tier. For example, in the following figure, workload WebApp1 is allocated 10% of tier resources. If the percentage of resources flowing into the tier is 80% of node resources, then WebApp1 is allocated only 8% of node resources.

"SLG tier resource allocation."

Requests in an SLG tier workload divide resource allocations equally. For example, if the workload is allocated a 5% share and there are five requests running concurrently, each request gets 1% of the shared resources.

To accommodate growth, Teradata recommends that you assign workloads a higher allocation percentage than you think is needed. If workload consumption varies over time, allocate the workload a different percentage for each planned environment. Do not relocate workloads to different SLG tiers in different planned environments.

If there is more than one SLG tier, the allocation percentages assigned to workloads on the higher tiers translate to a larger share of resources than those on the lower tiers. For example, SLG tier 1 workloads receive service ahead of SLG tier 2 workloads.

The unused resources flowing down from an SLG tier to the lower tiers equals 100% minus the sum of the workload allocation values on that tier. In the preceding figure, the sum of the three workload allocation values on the tier is 30%. This guarantees that at least 70% of the resources flowing into that tier are available to workloads in the lower tiers.

See the Orange Book, Teradata Priority Scheduler for Linux SLES 11, 541-0008867 for guidance on how to set up SLG tier workloads.