Tactical workload tuning is a particular discipline on Teradata. Tactical workload requires a unique skill set and tools. In this article, I will show you the skills needed to optimize the tactical workload. You will learn how to use the proper tools and the “tactical workload skill set.” The Difference between Tactical and Decision Support

Read More

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

What are Throttles used for in Teradata Workload Management? Throttles are used to limit the number of concurrent sessions, requests, or utilities. We use throttles in Teradata workload management to protect critical resources – such as memory, AMP worker tasks, and CPU – from being exhausted. Throttles’ usage helps to reduce resource contention on systems

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