16.10 - Key Recommendations for Workloads - Teradata Workload Management

Teradata Database Workload Management User Guide

prodname
Teradata Workload Management
vrm_release
16.10
created_date
June 2017
category
Administration
User Guide
featnum
B035-1197-161K
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.