sqlserver 查看tempdb使用详情

查看占用空间较大的数据库对象，数据库会话 use tempdb   go   SELECT top 10 t1.session_id,                                                       t1.internal_objects_alloc_page_count,  t1.user_objects_alloc_page_count,   t1.internal_objects_dealloc_page_count , t1.user_objects_dealloc_page_count,   t3.login_name,t3.status,t3.total_elapsed_time   from sys.dm_db_session_space_usage  t1    inner join sys.dm_exec_sessions as t3    on t1.session_id = t3.session_id    where (t1.internal_objects_alloc_page_count>0    or t1.user_objects_alloc_page_count >0   or t1.internal_objects_dealloc_page_count>0    or t1.user_objects_dealloc_page_count>0)   order by t1.internal_objects_alloc_page_count desc   #看是哪条sql导致的 select s.text,p.* from master.dbo.sysprocesses p    cross apply sys.dm_exec_sql_text(p.sql_handle) s   where spid = 94   SELECT     session_id,        status,     login_time,     host_name,     program_name FROM sys.dm_exec_sessions select * from sys.dm_exec_sessions where session_id=94; kill 94; use tempdb exec sp_spaceused ;