Sample Header Ad - 728x90

where is memory going in In-Memory OLTP?

1 vote
1 answer
85 views
I have only memory optimized table in my database. When I am running below query, I am getting pages_mb for that DB as 710 MB. SELECT type , name , memory_node_id , pages_kb/1024 AS pages_MB FROM sys.dm_os_memory_clerks WHERE type LIKE '%xtp%' But when I run below query, I am getting mem_alloc_total_mb for that table as 2 and others as 0. SELECT object_name(object_id) AS table_name, memory_allocated_for_indexes_kb / 1024 as mem_alloc_index_mb, memory_allocated_for_table_kb / 1024 as mem_alloc_table_mb, memory_used_by_indexes_kb / 1024 as mem_used_index_mb, memory_used_by_table_kb / 1024 as mem_used_table_mb, (memory_allocated_for_table_kb + memory_allocated_for_indexes_kb) / 1024 as mem_alloc_total_mb, (memory_used_by_table_kb + memory_used_by_indexes_kb) /1024 as mem_used_total_mb FROM sys.dm_db_xtp_table_memory_stats where object_id = object_id(''); go Data from both the above queries are contradicting each other. Am I missing anything? *NOTE: Durability setting for the memory optimized tabe is "SCHEMA_AND_DATA".*
Asked by sachin-SQLServernewbiee (473 rep)
Oct 21, 2020, 04:00 PM
Last activity: Oct 21, 2020, 07:37 PM