Recommendations for Workloads | Teradata Vantage - 17.00 - Key Recommendations for Workloads - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
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.