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

title	Memory-Optimized Table Dynamic Management Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	02/01/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	in-memory-oltp
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	ccd82fed-1a3f-47de-85c4-1c9bdd80b027
author	stevestein
ms.author	sstein
manager	craigg
monikerRange	=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Memory-Optimized Table Dynamic Management Views (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2014-asdb-xxxx-xxx-md]

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

For more information, see In-Memory OLTP (In-Memory Optimization).

sys.dm_db_xtp_checkpoint_stats (Transact-SQL)	sys.dm_db_xtp_checkpoint_files (Transact-SQL)
sys.dm_db_xtp_gc_cycle_stats (Transact-SQL)	sys.dm_db_xtp_hash_index_stats (Transact-SQL)
sys.dm_db_xtp_index_stats (Transact-SQL)	sys.dm_db_xtp_memory_consumers (Transact-SQL)
sys.dm_db_xtp_merge_requests (Transact-SQL)	sys.dm_db_xtp_object_stats (Transact-SQL)
sys.dm_db_xtp_nonclustered_index_stats (Transact-SQL)	sys.dm_db_xtp_table_memory_stats (Transact-SQL)
sys.dm_db_xtp_transactions (Transact-SQL)	sys.dm_xtp_gc_queue_stats (Transact-SQL)
sys.dm_xtp_gc_stats (Transact-SQL)	sys.dm_xtp_system_memory_consumers (Transact-SQL)
sys.dm_xtp_transaction_stats (Transact-SQL)

Object Catalog Views

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

sys.hash_indexes (Transact-SQL)	sys.memory_optimized_tables_internal_attributes (Transact-SQL)

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