17.10 - Assigning Priority Levels - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)
You can assign priority levels to Teradata system recovery or table rebuild by using the PRIORITY command feature of rcvmanager. Control over job priority is assigned by selecting one of three priority levels:
  • HIGH
  • MEDIUM
  • LOW

For information about these priority levels, see REBUILD/RECOVERY PRIORITY.

Teradata system recovery and disk rebuild are primarily I/O intensive tasks. The major portion of the time taken by a given task is involved in setting up for or waiting for completions of a disk or a BYNET message traffic operation. Very little manipulation or computation is required on the data once it is available.

If the competing work load of the Teradata system can be reasonably characterized, then you can gauge the impact of the priority changes to recovery and rebuild operations. In general, use the following guidelines when assigning priorities:

Guideline Description
No work load competition If there is no competition for resources as in a COLDWAIT restart for recovery, the priority setting of the recovery and rebuild jobs will have no practical effect.
Compute-intensive work load If the online Teradata system work load is heavily compute intensive, raising the priority of the I/O intensive recovery operations can dramatically improve the recovery (including rebuild).

The high recovery will have a relatively minor impact on the online Teradata system operations. However, it will provide a better resource utilization and result in better Teradata system throughput. Similarly, a low priority of recovery in this work load will dramatically slow down recovery with only a moderate gain in online throughput.

Moderate or heavy disk work load If a moderate or heavy amount of disk and/or BYNET usage occurs by the online system, then recovery will show moderate throughput changes by controlling the priority setting but with a larger impact against the Teradata system throughput. Memory contention becomes a major component of operation in these cases.
I/O saturation As the I/O utilization approaches saturation, there are fewer opportunities to improve throughput or execution time of either the online Teradata system or the recovery job. In this case, we are competing for the same resource and that resource is not amenable to manipulation by control over the scheduling priority.