• This can also happen if your query's execution plan is creating extremely large hash tables or sort operations in the background and spooling out to tempdb.

    Use the following DMV query to see what sessions have space allocated in TEMPDB.

    select * from sys.dm_db_task_space_usage

    where (internal_objects_alloc_page_count + user_objects_alloc_page_count) > 0

    order by (internal_objects_alloc_page_count + user_objects_alloc_page_count) desc;

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho