sys.dm_db_xtp_memory_consumers

Description

Reports the database-level memory consumers in the In-Memory OLTP database engine. The view returns a row for each memory consumer that the database engine uses. Use this DMV to see how the memory is distributed across different internal objects. In-Memory OLTP overview and usage scenarios ID (internal) of the memory consumer. 0 = Aggregation. (Aggregates memory usage of two or more consumers. It shouldn’t be displayed.)

Syntax

memory_consumer_type_desc