memory-optimized-table-dynamic-management-views-transact-sql.md

title	In-Memory OLTP System Views (Transact-SQL)
description	Learn about dynamic management views and object catalog views used with In-Memory OLTP.
author	rwestMSFT
ms.author	randolphwest
ms.date	04/29/2025
ms.service	sql
ms.subservice	in-memory-oltp
ms.topic	reference
dev_langs	TSQL
monikerRange	=azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current
ms.custom	build-2025

In-Memory OLTP System Views (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi]

For more information, see In-Memory OLTP overview and usage scenarios.

Dynamic management views

The following dynamic management views (DMVs) are used with In-Memory OLTP:

• sys.dm_xtp_gc_queue_stats
• sys.dm_xtp_gc_stats
• sys.dm_xtp_system_memory_consumers
• sys.dm_xtp_transaction_stats
• sys.dm_db_xtp_checkpoint_files
• sys.dm_db_xtp_checkpoint_stats
• sys.dm_db_xtp_gc_cycle_stats
• sys.dm_db_xtp_hash_index_stats
• sys.dm_db_xtp_index_stats
• sys.dm_db_xtp_memory_consumers
• sys.dm_db_xtp_merge_requests
• sys.dm_db_xtp_nonclustered_index_stats
• sys.dm_db_xtp_object_stats
• sys.dm_db_xtp_table_memory_stats
• sys.dm_db_xtp_transactions
• sys.dm_db_xtp_undeploy_status

Object catalog views

The following object catalog views are used with In-Memory OLTP.

• sys.hash_indexes
• sys.memory_optimized_tables_internal_attributes

Internal DMVs

There are additional DMVs that are intended for internal use only, and for which we provide no direct documentation. In the area of memory-optimized tables, undocumented DMVs include the following:

• sys.dm_xtp_threads
• sys.dm_xtp_transaction_recent_rows