In-memory OLTP with SQL Server 2016
0 h 40 m
In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.
In this exercise you will create the database that will contain both the memory-optimized tables and disk-based tables that you will use for the lab exercise. You will also create workload table to document the results of your changes throughout the lab. Finally, you will document the baseline performance of your workload.
In this exercise, you will implement all of the various in-memory OLTP technologies and document the performance improvement for each one.