Than you for the query,

but I need more info, because

now tempDB is 20 gb with 98% free space and no chance to shrink it.

I suppose some SP has used lot of space but I don't know witch one?

... the job has finish.

the second query gives me host_name without the SP_name and I have

more SP working from the different host_name.

the article suggested by free_mascot

http://technet.microsoft.com/hi-in/library/cc966545(en-us).aspx#EBAA

gives some more info but has a bug

I've compiled the sp but I got this error when I run it:

Msg 8152, Level 16, State 14, Procedure sp_sampleTempDbSpaceUsage, Line 5

String or binary data would be truncated.

The statement has been terminated.

So till now I don't know witch procedure is exhausting the black box I hate most (tempDB).

Please don't' get me wrong, but I really have trouble understanding what does not work.

Than you,

Lorenzo