There are four major components of SQL memory architecture…
1. Memory Broker
2. Memory Object
3. Memory Clerk
4. Memory Node
In short, BOCN. (For remember it “Boy Of Cartoon-Network”)
1. Memory Broker
Purpose of Memory Broker is to provide a centralized mechanism to distribute/control memory the allocation made by each component in SQL Server.
Note: Memory brokers do not perform any allocations.
Below are the types of Memory Broker…
A. MB for Cache
B. MB for Steal
C. MB for Reserve
D. MEMORYBROKER_FOR_COMMITTED
E. MEMORYBROKER_FOR_XTP
2. Memory Object
MO are memory allocations made through the clerks.
There are 3 types of MO
A. Variable MO
B. Shrink MO
C. Fixed Size MO
3. Memory Clerks
MC is the actual memory consumer of memory.
There are 4 types
A. Generic MC
B. Cache Store MC
C. Object Store MC
D. User Store MC
4. Memory Node
It’s a large memory pool from where different companies can allocate memory.
Number of MN depends on NUMA.
In MN, 4 types of allocation can be done…
A. Single page allocation
B. Multi page allocation
C. Large page allocation
D. Reserved page allocation
Leave a Reply