Archives of the TeradataForum

Message Posted: Thu, 27 Sep 2001 @ 19:25:57 GMT

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

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 workloads.

Basically keeping spool # much like disk and cpu # on resusage.

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