Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2000 @ 21:48:52 GMT


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


Subj:   Re: Experiences with the Priority Scheduler?
 
From:   Thomas F. Stanek

Great input and examples. It sounds like you are using it fairly extensively.

One comment, however, we use the ABS policy regularly and haven't had a problem with it. In fact, we move problem queries into the performance group with an ABS policy so that we can limit it's impact on the system while we determine whether the query should be aborted or not. We don't want to inadvertently abort a long running update for example.

In that same light, you might want to consider changing the system setting to force rollbacks to occur in the same performance group in which they were submitted. The default setting is $R, which can severely impact your overall system performance.

Tom Stanek
TFS Consulting



     
  <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