Utility Workload Throttles | Teradata Vantage - 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.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage
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.