Tags for workload management
Reserved AMP Worker Tasks Exclusively for Utility Jobs, Maybe
Teradata is a message passing system.  Messages are sent from parsing engines to AMPs, and from  AMPs to AMPs, and from AMPs to parsing engines.  That’s the key way that components in a shared nothing architecture pass data and work requests among themselves. When a message arrives on an AMP and the message represents work that needs to get done on the AMP, that message is assigned a“work type”, depending on the importance of the work-to-be-done.  There are 16 different work types supported:  Work00 to Work15.       Under usual conditions, all load utility jobs and all queries run using AMP worker tasks (AWTs) of the same message work types:  Work00, Work01, and Work02.  However, if you increase AWTs per AMP above a certain threshold, then all your utility jobs will be assigned to different work types and given their own reserve pools.    If you are someone who monitors or is otherwise interested in AWTs and how they are being used, this posting describes changes related to your utility jobs, and what options you have for managing these changes.
workload management load utilities amp worker tasks
A Closer Look at Tactical Workload Exceptions
Tactical workload exceptions are in place to prevent tactical queries from consuming unreasonable amounts of resources.  It is important to have this protection because the super-priority and almost unlimited access to resources given to work running in the Tactical tier with SLES 11 is easy to abuse.   
tasm workload management tactical workload exception
Being Smart About Using Workload Classification
Have you ever found yourself confused when setting up classification criteria for a new workload in Teradata?  You’re not alone.  This posting discusses the main principles at work when it comes to combining different classification criteria.  It also provides some general tips to help you do effective, clean, predictable classification, whether on your workloads, your throttles or your filters.
tasm workload management classification workload
Teradata Workload Management Release 15.0 /15.10 for SLES 11 Technical Overview
This webcast provides an overview of the Teradata Workload Management, consisting of Teradata Integrated Workload Management and Teradata Active System Management (TASM).
workload management teradata active system management (tasm) performance management mixed workload system performance
Teradata Workload Management Release 15.0 /15.10 for SLES 11 Technical Overview
A new database priority scheduler is introduced with the Linux SLES 11 operating system.
tasm workload management migration sles11
Special Treatment For Users DBC and TDWM
If you are user DBC or user TDWM and you log onto a Teradata Database, you might get treated somewhat differently than other users.  This posting describes what user DBC and user TDWM do, some of the special things about them, and when you can expect them to get treated differently.   We’ll also look at any implications in setting up workload management for these two special users.
teradata dbc tdwm workload management
Workload Management with SLES 11 – Tips and Techniques
This session covers the main topics of Workload Management on SLES 11 systems. 
tasm workload management TIWM sles 11
Workload Management Capacity on Demand and other SLES11 Hard Limits
This session explores the new options available for setting hard limits at different levels in the SLES11 priority hierarchy.
COD database workload management
DBQL - the Ultimate Query Tracker - Are You Up-to-Date?
Have you ever wished for a magic wand that could quickly point out the missing, stale, and unused statistics for you?
dbql data collection performance tuning workload management
Introduction to Teradata Active System Management (TASM)
TASM gives customers the ability to manage Teradata resource usage and performance on platforms executing diverse types of work.
viewpoint portlet workload management tasm workload

Pages