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.
Management of In-Memory objects
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.