Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Sep 2002 @ 15:59:25 GMT


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


Subj:   Re: Performance level setting question
 
From:   Alfino, Francesca M

Hi Daniel,

The problem is that amp worker tasks (now) run at the same priority (work allocation group setting) as the work they are supporting. You only get 60 per amp worker tasks before you run into flow control (you run out). Each utility and/or heavy duty sql takes so many amp worker tasks. There is a formula for what uses how many amp worker tasks.

We are in the process of setting up work allocation groups for managing the distribution of CPU. But that is a long involved process and this is somewhat of a different issue.

When you are out of amp worker tasks, you do not run at 100% CPU. Amp Worker Tasks become a resource constraint which is a separate issue from priority scheduler which would control CPU allocation for work groups. You cannot use all the CPU when you are in flow control.

All I hope to accomplish is to throttle down new work coming onto the system until the system is not saturated or prevent it from getting saturated.

FRANCESCA ALFINO
SENIOR DATABASE ADMINISTRATOR
Enterprise Data Warehouse
SBC Services, Inc.



     
  <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: 27 Dec 2016