Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 15 Aug 2012 @ 10:11:53 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: AWT Run Out
 
From:   Dieter Noeth

frank.c.martinez wrote:

  Actually, it's a pretty bad situation called flow control. Teradata sets a timer for queries and each one waits longer and longer for some AWT's to be available. Someone once described it to me as, "ok, query, go around the block the first time, then around a couple of blocks the next, then even more the next."  


This "someone" was probably Larry Higa in his Performance training :-)


  I'm sure Dieter could give a more technical and yet more illuminating description.  


I'm shure Carrie Ballinger can do that much better ;-) There's an Orange Book on AMP Worker Tasks and some posts in her blog:

developer.teradata.com/...

developer.teradata.com/...


Dieter



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020