金蝶K3WISE-tempdb空间使用情况1.txt

usetempdbgoSELECTtop10t1.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_timefromsys.dm_db_session_space_usaget1innerjoinsys.dm_exec_sessionsast3ont1.session_id=t3.session_idwhere(t1.internal_objects_alloc_page_count>0ort1.user_objects_alloc_page_co...