How to get tempdb space utilization

This query will let you know how much tempdb space is required by query.

 

GO

SELECT * FROM sys.dm_db_session_space_usage WHERE SESSION_ID = @@spid

GO

<Your Query>

GO

SELECT * FROM sys.dm_db_session_space_usage WHERE SESSION_ID = @@spid