16.10 - Examples: Throttles - 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
Some common targets of throttles include the following types of work:
  • Low-priority requests
  • Requests that consume many resources
  • Sandbox applications
  • Full-table scans of medium-sized or large tables
Examples of throttles include the following TASM actions:
  • Limit a specific user (source classification) to having no more than 10 sessions at a time (request session limit).
  • Limit the number of application X sessions (source classification) simultaneously executing against a table (target classification).
  • Allow no more than 3 concurrent data mining requests (source classification) because data mining uses significant resources and is not a high priority.
  • Limit requests based on characteristics, for example, statement type, step row count, or join properties.
  • Limit the number of requests that can run during end-of-the-month processing (Limits by State).