Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
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.
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 are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.