Recommendations for Workloads | Teradata Vantage - 17.10 - 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
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)
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.