Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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

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

  <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