22-25 April 2026
Book Now
SQLBits 2015

In-Memory OLTP, how to use it

We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability.
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability. Taking an entirely disk based system and modifying it to really make use of In-memory OLTP capabilities. We will look at how to identify good candidate workloads for In-memory OLTP, then we will look at how to go about moving to a hybrid system of disk based tables with memory optimised components within the database to enhance the capability to get the system to scale. I will show some options for identifying objects to migrate and some of the design considerations you will need to take into account if you want to make use of this feature.

Speakers

John Martin

blog.jqmartin.co.uk

John Martin's previous sessions

The Swiss Cheese Security Pattern
Understanding that there is no panacea when it comes to securing your data assets is important. We will look at how to adopt the right mindset and then build a secure architecture to minimise the risk to your data.
 
Introduction to Infrastructure as Code with Terraform
Join John as he introduces Terraform as a cloud agnostic management interface for taking a code first approach to cloud infrastrucutre deployments.
 
Making Managed Instance Perform, a dive into storage.
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance included, get the storage configuration wrong and it will not perform. We'll look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need
 
In-Memory OLTP, how to use it
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability.