15.00 - Using Priority Scheduler - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Using Priority Scheduler

Priority Scheduler can do the following for you:

  • Provide better service for your more important work
  • Control resource sharing among different applications
  • Automate changes in priority by time of day or by amount of CPU used
  • Place a ceiling on Teradata Database system resources for specific applications
  • When using Priority Scheduler, keep the following in mind:

  • Start out simple, monitor, and build from there.
  • You can change parameters at any time using the schmon utility.
  • Any changes you make to any parameter, including weight, take place immediately across all nodes in the configuration.
  • You can delete the definitions of unused Resource Partitions, Performance Groups, and Allocation Groups using a Teradata Database system utility like schmon. The element that you want to delete cannot be in use when you perform the deletion. This means that an Allocation Group or Resource Partition must not be referenced by a Performance Group, and a Performance Group must not be referenced by a currently logged on user.
  • You can change the name of a defined but unused Resource Partition or Performance Group to make it obvious it is unused. For example, you might name the unused Resource Partition or Performance Group UNUSED or NULL.