Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Sep 2009 @ 14:23:40 GMT


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


Subj:   Priority scheduler milestones
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, September 02, 2009 10:13 -->

1 How do we know that a query got demoted due to query miles stones? i mean if it gets demoted to next allocation group with lower priority, is there any place it stores this info other than the totalcputime in dbqlogtbl? I need to keep track of how many quesries getting demoted due to query milestones.

2) Is weight assigned to allocation group in Priority scheduler impacts the IO allocation also?

3) what exactly schmonnode table will contain?


Thanks



     
  <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