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 ...

Get SQL Server 2016 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.

Start your free trial