In-Memory OLTP table was first introduced in SQL Server 2014. However, a massive number of limitations makes In-Memory OLTP table usage practically impossible. In SQL Server 2016 many of those limitations were eliminated which made it possible to start implementing In-Memory OLTP table in the database. The session “Migrating a Disk-based Table to a Memory-optimized Table” will cover the process of migrating the disk tables to In-Memory OLTP table. This process is not straight forward and requires analysis before making a final decision for migration. However, the benefits of In-Memory OLTP table is worth the effort. If you are looking to improve transaction speed and reduce blocking for your server, the In-Memory OLTP tables is an excellent way to accomplish this task.
Alex Grinberg is a certified MS SQL Server professional and has more than 20 years IT experience. He provides SQL Server tuning, optimization, analysis, development, and administration services: creating new applications, converting legacy technologies (SQL Server, VB.NET and C#) and on-site training. Alex is a senior DBA at Cox Automotive. He is a member of the Board of Directors for PSSUG (Philadelphia). Alex also frequently attends and presents at SQLSaturday events around the country, sharing his passion for all things SQL Server. Alex is a guest author for SQLServerCentral.com and also a technical reviewer for Apress.