Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Jun 2002 @ 19:21:24 GMT


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


Subj:   Re: Limits of CPU
 
From:   Thomas F. Stanek

The relative and absolute policies are very affective in limiting the amount of system resources for ad hoc queries. As a general rule, I prefer using the relative policy only because it allows work in the associated performance group to use more of the system resources if they are available and not being used by other performance groups. However, if other performance groups are active, the relative policy effectively limits CPU consumption for the performance group. The absolute policy is a hard a fast limit. CPU resources will not exceed the limit, regardless of the other work on the system.

In both cases, you run the risk of idle CPU time that could otherwise be working on the requests executing in the limited performance group. Just something to be aware of.

Perhaps you could elaborate more on the types of problems your were having, the policies you implemented, etc.

Thomas F. Stanek
TFS Consulting
www.tfsconsulting.com



     
  <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