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 higher than work from Becky would normally classify.