memoryclerks vs memoryobject vs memory pools

Question

Hi all , just want to know the difference of memory clerks and memory objects and what's are their relationship ?

another question is why virtual_memory_committed_kb is much less than pages_kb??

pages_kb is the size that memory clerks memory are in PHYSICAL MEMORY ?

I would also ask questions on memory pools sys.dm_os_memory_pools, pool_id 0 is the internal pool ? pool_id 1 is default pool ? is it referring resource default /internal pool ?. how it's mapped with memory clerk ?

Answer 1

Hi @sakuraime ,

so sum(pages_in_bytes)=pages_kb ??

No.
Try code as next:

use Dbname
go

SELECT SUM (pages_in_bytes) FROM sys.dm_os_memory_objects

select sum(pages_kb) from sys.dm_os_memory_clerks

If the reply is helped, please do “Accept Answer”.
BR,
Mia

Answer 2

Hi @sakuraime ,

Is the reply helpful?

If the reply is helped, please do “Accept Answer”.
BR,
Mia