The related views are:
- sys.dm_db_session_space_usage – helps you track down who’s using space in TempDB by session_id.
- sys.dm_db_file_space_usage – for each file in TempDB, this DMV lists the amount of pages used by user objects, the version store, and internal objects.
- sys.dm_db_task_space_usage – like session_space_usage, but by individual request (query).
Some of our favorite utility queries for these are:
- sp_WhoIsActive – using these DMVs, it can show which sessions are using TempDB space.
