Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Mar 2003 @ 16:18:41 GMT


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


Subj:   Spool guestimates
 
From:   McCann, Andy

Does anyone have any recommendations for upper spool limits? Based on previous experience I have set some limits at our site and they have become de-facto standards. This is no bad thing as they have helped flush out a number of bad, skewing queries but have been generous enough to get 99% of queries through, even the most complex BO queries against large tables. I would however, be grateful for any input anyone may have on what type of strategy they have set at their sites so I can refine my standards and thinking. I can see some users needing more than my de-facto standards and some less. Relative percentages of largest table to spool would do, especially from sites with very large tables.

For info, we have several small tables then a handful of huge tables (up to 600 Gb - but let's not get into the who's got the largest table argument.) We have a very mixed workload on the box.

To save everyone's time, I know all the well known stuff about spool, reserves etc and the implications of giving everyone to much, I'm really just after some ideas on the strategies that are working successfully out there.


Cheers

Andy



     
  <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