In case this is helpful to anybody, I have a similar query a to identify processes actively running that take up Tempdb space.

I found this useful as sometimes we would...

Cheers for the script, I made a few adjustments to include the schema in the table Name (we have some databases which have multiple schemas). Also made a change to...