Teradata Utility Workload – Overview Our previous articles about Teradata workload management covered the basics of how SQL requests are classified into workloads. We talked about throttles, dynamic workload management, and the priority scheduler. This article is covering the utility workload. Utility jobs are user requests which are not implementing the SQL protocol. Currently, this

Read More

Dynamic workload management features are only available on systems using Teradata Active System Management (TASM). Teradata Integrated Workload Management (TIWM) doesn’t offer most of these features. What is Teradata Dynamic Workload Management Features? While TIWM solely relies on static workload definitions (with a few exceptions we will mention later), TASM offers features that allow us

Read More

In our previous article, we defined the term workload and described how the Teradata workload management classifies requests (queries) into workloads. We mentioned shortly, that resource allocation (CPU seconds and IOs) is one of the main reasons why we are grouping requests. If you are new to workload management I would highly recommend that you read

Read More

Everyone who has some experience with Teradata tuning will have heard the term “workload.” This article will deal with the definition of this term and explain in detail what it is and why it’s helpful to map each request (query or load operation) to a workload. What is Teradata Workload? A workload is a group of requests

Read More