Migrating disk-based objects to In-Memory OLTP

Lots of systems were built a long time before In-Memory OLTP was born. Such systems would enhance performance but maybe the traditional method of optimization would fail. For these cases, Microsoft offers reports and wizards helping with migration of tables and stored procedures to the In-Memory environment.

The first question is which tables are suitable to be migrated to the In-Memory OLTP to improve performance. The second question is how expensive the migration could be. The migration of tables and stored procedures to the In-Memory OLTP has to be transparent to the applications using it, otherwise significant effort will be needed to remake some part of the client applications due to the ...

Get SQL Server 2017 Administrator'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.