|
|
Archives of the TeradataForum
Message Posted: Wed, 15 Aug 2012 @ 10:11:53 GMT
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
| |