Tags for flow control
Identifying Sessions Causing AWT exhaustion
The  Teradata system is going into frequent flow control.There are a few sessions running with high CPU skewness. Is there any query to know which sessions are consuming maximum AWTs , so that we can abort those to bring the system health back to normal?   Thanks in Advance!!
flow control AWT exhaustion
AMP Worker Tasks
This session gives a close-up picture of what AMP worker tasks are and how they support user work.
database amp worker tasks performance flow control message queue
How do you stop demoted queries from hogging CPU?
We have implemented a 'Penalty Box' workload within TASM for queries that are demoted after reaching specific exception criteria with the idea that they go into a workload which has a low CPU allocation. We have seen a high % of CPU be taken into the Penalty box and remain with the query for a significant period.
tasm workload exception handling flow control
Flow Control and Spawned Work
There’s a comment on an earlier blog posting of mine from 2009 titled Controlling the Flow of Work in Teradata.  The comment poses a question that is more reasonably answered by making second posting on flow control. 
database amp worker tasks flow control