Management of in-memory objects

Managing memory-optimized tables is similar to disk-based tables. SQL Server Management Studio provides full syntax and GUI support for memory-optimized tables. There is a long list of Dynamic Management Objects (DMOs) that provide detailed insights into each aspect of the feature, but the legacy management objects such as sys.tables or sys.indexes have also received some updates to include pertinent memory-optimized information.

Dynamic management objects

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

• sys.dm_db_xtp_checkpoint
• 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 of the columns and meanings for each DMO can be found in Microsoft...