Recommendations for Workloads | Teradata Vantage - Key Recommendations for Workloads - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
pzr1600284001549.ditamap
dita:ditavalPath
pzr1600284001549.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage
The goal when creating a workload is to efficiently manage system work and minimize workload administration. To achieve this balance, use the following guidelines:
  • Create a workload only when there is a clear need (5-20 workloads are enough for most sites).
  • Simplify workload classification wherever possible so that the effects are clear.
  • Classify workloads first by request source or query band because these criteria are the most exact and predictable. Many customers use the request source option Profile, which categorizes work according to environment and role.
  • Use target criteria, request characteristics, and utility criteria mainly as secondary classification criteria to achieve further differentiation between request sources and query bands.