CREATE VIEW [dbo].[tempusage]
AS
SELECT task.session_id,
	   SUM(task.user_objects_alloc_page_count - task.user_objects_dealloc_page_count + task.internal_objects_alloc_page_count - task.internal_objects_dealloc_page_count) * 8192 / 1024 / 1024 AS [tempdb usage, MB],
	   q.[text] sql_text,
	   sess.host_name,
	   sess.program_name,
	   sess.login_name,
	   DB_NAME(sess.database_id) from_db
FROM sys.dm_db_task_space_usage task
LEFT JOIN sys.dm_exec_requests req ON req.session_id = task.session_id
LEFT JOIN sys.dm_exec_sessions sess ON sess.session_id = task.session_id
OUTER APPLY sys.dm_exec_sql_text(req.sql_handle) q
WHERE task.database_id = DB_ID('tempdb')
GROUP BY task.session_id,
		 q.[text],
		 sess.host_name,
		 sess.program_name,
		 sess.login_name,
		 DB_NAME(sess.database_id)
HAVING SUM(task.user_objects_alloc_page_count - task.user_objects_dealloc_page_count + task.internal_objects_alloc_page_count - task.internal_objects_dealloc_page_count) * 8192 / 1024 / 1024 > 0;