16.10 - Utility Workload Throttles - Teradata Workload Management

Teradata Database Workload Management User Guide

Teradata Workload Management
June 2017
User Guide
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.