usetempdb go SELECT top 10t1.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 fromsys.dm_db_session_space_usage t1 inner join sys.dm_exec_sessions ast3 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 select 528*8/1024/1024 as [size_GB] select p.*,s.text frommaster.dbo.sysprocesses p crossapply sys.dm_exec_sql_text(p.sql_handle) s where spid = 75
SQL SERVER 查看占用tempDB
免责声明:文章转载自《SQL SERVER 查看占用tempDB》仅用于学习参考。如对内容有疑问,请及时联系本站处理。
上篇Java根据参数返回相应类2016 系统设计第一期 (档案一)jQuery radio 取值赋值下篇
宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=