Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Dec 2001 @ 12:59:57 GMT


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


Subj:   Teradata Priorities
 
From:   Tony Howe

I have a resource/CPU usage question and just how does Teradata allocate it as to who gets how much and how can one query suck up all or a lot of resources when every USER logging on has the same priority?? I other words, all of the USER on our system are given a priority of $M. So to me that means they all should get equal time and resources to run their queries, but occasionally it appears that one user gets in there with a big/intensive query and appears to be the only one getting any time and resources. As soon as I dynamically change his priority to $L, then the other queries out there take off and running.

The weight for the four default priorities are $L = 5, $M= 10, $H = 20 and $R = 40, I haven't change any of these settings since the server was brought in. I am looking at this Priority Scheduler stuff that everyone talks about because I am about to add a second application to our 5250 and each application is worried about the other not fairly sharing the system. But if everyone has a $M priority why doesn't everyone get equal time/resources? Why do I have to even think about using this complicated Priority Scheduler stuff??? I'm not getting it???

Thanks, Tony.



     
  <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