Archives of the TeradataForum
Message Posted: Wed, 30 Jun 2004 @ 12:24:04 GMT
| Subj: || || Re: How do I calculate Spool Usage |
| From: || || Tewksbury, Kevin |
I would recommend using dbc.allspace. In the dbc.databasespace table the databasename is only an ID (an integer value), you would have to join
to dbc.dbase to get/convert the username to get their ID for the databasespace table. The below query will give you space used by vproc. You can
run this while the user query is running and order by 2 desc (currentspool) to see if the query is "hot amping" as well. We typically will
clearpeakdisk for a user, have them run their query and monitor during (with currentspool) and after (with peakspool).
select vproc, sum(currentspool), sum(peakspool), sum(maxspool)
where databasename = 'xxxxxxxx'
group by 1
order by 3 desc