Archives of the TeradataForum
Message Posted: Thu, 27 Sep 2001 @ 19:25:57 GMT
| Subj: || || Re: Max Spool Usage |
| From: || || Steve Bracewell |
As do we (and most shops). It still does not answer the question as asked. The key would be cumulative max spool by time.
Would it not hypothetically look something like 'select "allspool", time from dbc.allspool where spool date in last period order by
allspool desc'. Or if simply wanting to know the max spool for the last period, take out time. Of course with time (like nice 10 minute
increments) you could then tell what % of the time you were at some threshold, something valuable when either sizing a box or revisiting
Basically keeping spool # much like disk and cpu # on resusage.