SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 10, 2008.

  1. Anonymous New Member

    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...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/01/10/3154.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3154" width="1" height="1">

Share This Page