Utility Workload Throttles | Teradata Vantage - 17.10 - Utility Workload Throttles - 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)
Use utility workload throttles to define more detailed utility limits. For example, to allow user Becky to run no more than 2 FastExport utilities, do the following:
  • Create a workload with the following classification criteria:
    • Username = Becky
    • Utility = Standalone FastExport
  • Set the workload throttle to 2
Only the utility work classifies with this criteria, the corresponding auxiliary SQL session classifies to whichever workload a request from Becky would normally classify to.
If work from Becky normally classifies to a workload that would risk exposing the utility auxiliary SQL session to unacceptable delays, consider the following strategy:
  • Creating a workload to classify utility auxiliary SQL work by the application name request source criteria. This workload would not have a throttle.
  • Placing this workload in the workload evaluation order above where work from Becky would normally classify.