title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
---|---|---|---|---|---|---|---|---|---|---|
Memory-optimized table Dynamic Management Views (Transact-SQL) |
Learn about the SQL Server dynamic management views and object catalog views used with In-Memory OLTP in SQL Server. |
rwestMSFT |
randolphwest |
02/01/2017 |
sql |
in-memory-oltp |
reference |
|
=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEsql-asdb-asdbmi]
The following [!INCLUDEssNoVersion] dynamic management views (DMVs) are used with In-Memory OLTP:
For more information, see In-Memory OLTP (In-Memory Optimization).
:::row::: :::column::: sys.dm_db_xtp_checkpoint_stats (Transact-SQL)
[sys.dm_db_xtp_gc_cycle_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-gc-cycle-stats-transact-sql.md)
[sys.dm_db_xtp_index_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-index-stats-transact-sql.md)
[sys.dm_db_xtp_merge_requests (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-merge-requests-transact-sql.md)
[sys.dm_db_xtp_nonclustered_index_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-nonclustered-index-stats-transact-sql.md)
[sys.dm_db_xtp_transactions (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-transactions-transact-sql.md)
[sys.dm_xtp_gc_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-xtp-gc-stats-transact-sql.md)
[sys.dm_xtp_transaction_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-xtp-transaction-stats-transact-sql.md)
:::column-end:::
:::column:::
[sys.dm_db_xtp_checkpoint_files (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-checkpoint-files-transact-sql.md)
[sys.dm_db_xtp_hash_index_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-hash-index-stats-transact-sql.md)
[sys.dm_db_xtp_memory_consumers (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-memory-consumers-transact-sql.md)
[sys.dm_db_xtp_object_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-object-stats-transact-sql.md)
[sys.dm_db_xtp_table_memory_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-db-xtp-table-memory-stats-transact-sql.md)
[sys.dm_xtp_gc_queue_stats (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-xtp-gc-queue-stats-transact-sql.md)
[sys.dm_xtp_system_memory_consumers (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-xtp-system-memory-consumers-transact-sql.md)
:::column-end:::
:::row-end:::
The following object catalog views are used specifically with In-Memory OLTP.
:::row::: :::column::: sys.hash_indexes (Transact-SQL) :::column-end::: :::column::: sys.memory_optimized_tables_internal_attributes (Transact-SQL) :::column-end::: :::row-end:::
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