Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

TSQL to get a quick information on detailed distribution of memory allocated

By design the components that are aware of the SQL Server memory management mechanisms use the buffer pool for small memory allocations. If the allocation is bigger than 8 KB, these components use memory outside of the buffer pool through the multi-page allocator interface.

select 
    type, sum(multi_pages_kb) 
from 
    sys.dm_os_memory_clerks 
where 
    multi_pages_kb != 0 
group by type

More detailed information about memory allocation by the server components can be assessed by using the sys.dm_os_memory_clerks DMV.

Published Thursday, January 10, 2008 2:04 PM by SQL Master

Comments

# TSQL to get a quick information on detailed distribution of memory allocated

By design the components that are aware of the SQL Server memory management mechanisms use the buffer

Thursday, January 10, 2008 2:40 PM by Other SQL Server Blogs around the Web

# TSQL to get a quick information on detailed distribution of memory allocated

By design the components that are aware of the SQL Server memory management mechanisms use the buffer

Thursday, January 10, 2008 3:07 PM by SSQA.net - SqlServer-QA.net
Anonymous comments are disabled