Browse by Tags

• dmv
• management
• memory
• sql server
• tsql

TSQL to get a quick information on detailed distribution of memory allocated
10 January 08 02:04 PM | SQL Master | 2 Comments   

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 Read More...

Filed under: tsql, sql server, dmv, memory, allocated, distribution, management, memory_clerk