Sep 20, 2020

SQL Server Memory Architecture


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")

SQL Server Memory Architecture




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








No comments:

Post a Comment

If you have any doubt or question, please contact us.