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


Updated: August 29, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2014)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

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

Object Catalog Views

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

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

Community Additions