SQLBits 2019

Identify opportunities for In-Memory OLTP

The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.
InMemory optimized tables is a feature introduced in SQL Server 2014 that is still underused. It provides significant performance gains for OLTP workloads. But still there are a lot of concerns about its usage. The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects. The session will go through the number of potential use cases and facilitates implementation with less development effort and risk.