27,581
社区成员




-- 查询tempdb数据库文件及文件大小
select file_id,type_desc,name,physical_name,[filesize(MB)]=cast(size*8/1024.0 as decimal(10,2))
from master.sys.master_files
where database_id=db_id('tempdb')
select session_id,user_objects_alloc_page_count=sum(user_objects_alloc_page_count*8.0/1024/1024),internal_objects_alloc_page_count=sum(internal_objects_alloc_page_count*8.0/1024/1024)
from (
select session_id,user_objects_alloc_page_count,internal_objects_alloc_page_count
from tempdb.sys.dm_db_task_space_usage(nolock)
where database_id=2
union all
select session_id,user_objects_alloc_page_count,internal_objects_alloc_page_count
from tempdb.sys.dm_db_session_space_usage(nolock)
where database_id=2
) a
group by session_id