What Are Tiers and Access Levels? - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem

When a workload is created in SLES 11, it is assigned to one of the following workload management methods:

Tactical
Manages high-priority, critical queries with a short response-time requirement.
SLG Tier
Allocates resources according to the SLG tier on which the workload resides. Multiple tiers can be prioritized so higher-level tiers have higher resource allocation. This method is not used in systems with an IWM license.
Timeshare
Assigns the following access levels that indicate the priority of resource allocation:
Low
This is the baseline and lowest resource access rate for the Timeshare access method.
Medium
Queries are given an access rate 2 times the Low access level.
High
Queries are given an access rate 4 times the Low access level.
Top
Queries are given an access rate 8 times the Low access level.