Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Jul 2009 @ 15:42:11 GMT


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


Subj:   Re: Blocking processes in Teradata
 
From:   Diehl, Robert

Chaim,

Only condition I can think of that will cause Perfromance problems with blocking is if a fair amount of process are blocked at the same time and then all the blocked processes execute at the same time. This can cause an uneven amount of demand on the server (peaks and valleys) and also depletion of AMP worker tasks during the peaks. Some of this can be smoothed out with queuing of queries with TASM.


Thanks,

Bob Diehl



     
  <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: 15 Jun 2023