Utility Workload Throttles | Teradata Vantage - 17.10 - Utility Workload Throttles - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Advanced SQL Engine
Teradata Workload Management
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
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.