The Top 25 sessions grid captures Tempdb space usage at the time the last SQL statement for the session completed. This grid is populated from sys.dm_db_file_space_usage.
Edit me

Session ID

The ID of the session generating Tempdb usage.

Total Space

The total space in Tempdb consumed by this session.


The application generating Tempdb usage.


The name of the Windows server hosting the SQL Server instance.


The SQL Server login name for this session.

Current SQL

The SQL statement last completed.

Internal Objects Space

The space consumed by internal objects in all tasks in this session.

User Objects Space

The total space used by user objects in this session.