Skip to content

Instantly share code, notes, and snippets.

@yurifedoseev

yurifedoseev/sql space usage.sql

Last active February 22, 2017 06:42
Show Gist options
  • Save yurifedoseev/7647347 to your computer and use it in GitHub Desktop.
Save yurifedoseev/7647347 to your computer and use it in GitHub Desktop.
Download ZIP
sql space usage
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment