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.