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.
Presented by John Q Martin at SQLBits XIV
MP4 Video HD 722 MB