Introduction

Teradata workloads are an essential aspect of managing database performance and resource allocation. They consist of collections of requests that share similar attributes, such as query type, user group, or application. By grouping these requests, database administrators can more effectively categorize, monitor, and analyze the utilization of system resources, such as CPU, memory, and I/O.

Each query is always assigned to a specific workload based on the classification criteria defined for that workload. The classification criteria consider the query's characteristics and the login information associated with the session to which the query belongs.

For instance, if a query matches the classification criteria of a workload in Timeshare TOP, it will be executed within that workload. Similarly, if the query matches the classification criteria of a workload in an SLG tier, it will run within that workload. This way, workload management effectively determines the appropriate workload for each query, ensuring optimal resource allocation and system performance.

If a given query could potentially map to two workloads, one with classification based on user and another on account, the Workload Evaluation Order in TASM will determine which workloads the query will utilize. When finding a suitable workload for a query, the workload management assesses all possible workloads in the Workload Evaluation Order. It then matches the query to the first workload where the classification criteria are met.