Utility Workload Throttles | Teradata Vantage - 17.00 - Utility Workload Throttles - 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
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.