How to identify what is growing the temp file of a database?

Have a look at connection properties (call sa_conn_properties()
and in particular 'TempTablePages' property:

"Returns the number of pages in the temporary file used for temporary
tables."

the connection that uses the largest number of table pages is most likely
the one that causes tempfile to grow.

e.g.

select * From sa_conn_properties() where PropName like 'TempTablePages'
order by convert(integer,value) desc

will list all the connection ordered (descending) by number of temp table
pages.

Lucjan


"Martin" <mm7141 (AT) googlemail (DOT) com> wrote