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

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance

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