There are four major components of SQL memory architecture...
1. Memory Broker
2. Memory Object
3. Memory Clerk
4. Memory Node
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...
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.
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.
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
In MN, 4 types of allocation can be done...
A. Single page allocation
B. Multi page allocation
No comments:
Post a Comment
If you have any doubt or question, please contact us.