Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jul 2010 @ 09:56:59 GMT


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


Subj:   Combining Object Throttles (User/Profile) & Workload Query Limits
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, July 26, 2010 12:17 -->

We are looking at limiting the number of queries a given workload definition can have. In addition, we want to ensure, that no one group/user has the ability to saturate a given workload definition; thus the potential need for object throttles at the user/profile level as well.

It's understood that queries may be delayed twice, once at the object level, and again at the workload definition level. Does anyone have any practical experience combining these two throttles? Any best practice advice is appreciated.



     
  <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