Archives of the TeradataForum
Message Posted: Tue, 11 Mar 2003 @ 16:18:41 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|