Dynamic management objects

The DMOs concerned with the In-Memory OLTP engine all have eXtreme Transaction Processing (XTP) in their name:

  • sys.dm_db_xtp_checkpoint_stats
  • sys.dm_db_xtp_checkpoint_files
  • sys.dm_db_xtp_gc_cycles_stats
  • sys.dm_xtp_gc_stats
  • sys.dm_xtp_system_memory_consumers
  • sys.dm_xtp_threads
  • sys.dm_xtp_transaction_stats
  • sys.dm_db_xtp_index_stats
  • sys.dm_db_xtp_memory_consumers
  • sys.dm_db_xtp_object_stats
  • sys.dm_db_xtp_transactions
  • sys.dm_db_xtp_table_memory_stats

Full details to the columns and meanings for each DMO can be found in Microsoft Books Online (https://msdn.microsoft.com/library/dn133203(SQL.130).aspx).

Get SQL Server 2017 Developer's Guide 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.