Welcome to

SqlServer-QA.net

Sign in | Join | Help

Browse by Tags

All Tags » memory_clerk   (RSS)

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