Monitoring Transactions on Memory-Optimized Tables

Since transactions on memory-optimized tables are handled separately from transactions on disk-based tables, the standard DMVs for monitoring transactions don’t provide information on memory-optimized table transactions. SQL Server 2014 provides the new sys.dm_db_xtp_transactions DMV for monitoring in-progress transactions on memory-optimized tables.

Click here to view code image

SELECT xtp_transaction_id ,          transaction_id ,          session_id ,          begin_tsn ,          end_tsn ,          state_desc       FROM sys.dm_db_xtp_transactions       WHERE transaction_id > 0;go/* sample outputxtp_transaction_id transaction_id session_id begin_tsn end_tsn state_desc------------------ -------------- ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial