yurifedoseev · February 22, 2017 06:42
diff --git a/sql space usage.sql b/sql space usage.sql
 select * 
 from sys.dm_db_session_space_usage spu
 join sys.dm_exec_sessions s on s.session_id = spu.session_id
 join sys.dm_exec_requests r on s.session_id = r.session_id
 cross apply sys.dm_exec_sql_text(sql_handle) t 
 order by internal_objects_alloc_page_count desc
	select *
	from sys.dm_db_session_space_usage spu
	join sys.dm_exec_sessions s on s.session_id = spu.session_id
	join sys.dm_exec_requests r on s.session_id = r.session_id
	cross apply sys.dm_exec_sql_text(sql_handle) t
	order by internal_objects_alloc_page_count desc