Management of In-Memory objects

Managing memory-optimized tables is similar to disk-based tables. SQL Server Management Studio provides a full syntax and GUI support for memory-optimized tables. There is a long list of DMOs that provide detailed insights into each aspect of the feature, but also 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 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...