In-memory OLTP with SQL Server 2016
Lab
Intermediate
0 h 40 m
2019-04-02
Lab Overview
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.

Related Learning Path(s):
SQL Server 2016 Advanced Features
Exercises
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. 

Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More