SQL Server TempDB Doldu: Alanı Kimin Tükettiğini Bulma

SELECT file_id,
       total_page_count * 8 / 1024 AS total_mb,
       unallocated_extent_page_count * 8 / 1024 AS free_mb,
       user_object_reserved_page_count * 8 / 1024 AS user_mb,
       internal_object_reserved_page_count * 8 / 1024 AS internal_mb,
       version_store_reserved_page_count * 8 / 1024 AS version_store_mb
FROM tempdb.sys.dm_db_file_space_usage;

SELECT TOP (20) s.session_id, s.login_name, s.host_name,
       (u.user_objects_alloc_page_count-u.user_objects_dealloc_page_count)*8/1024 AS user_mb,
       (u.internal_objects_alloc_page_count-u.internal_objects_dealloc_page_count)*8/1024 AS internal_mb
FROM sys.dm_db_session_space_usage AS u
JOIN sys.dm_exec_sessions AS s ON s.session_id = u.session_id
WHERE s.is_user_process = 1
ORDER BY (u.user_objects_alloc_page_count-u.user_objects_dealloc_page_count
        +u.internal_objects_alloc_page_count-u.internal_objects_dealloc_page_count) DESC;