SQL Server T-SQL Recipes, Fourth Edition

CHAPTER 19

In-Memory OLTP

by Wayne Sheffield

Perhaps the most anticipated new feature in SQL Server 2014 is the In-Memory OLTP database engine component. As its name implies, this new component works with memory-resident data. Current OLTP workloads, which read the pages from disk, need to take and release locks and latches, and they need to wait for log writes to be performed. In-Memory OLTP was designed for high concurrency with no blocking, which leads to In-Memory OLTP having tremendous performance improvements. This is accomplished by a new optimistic concurrency control model and latch-free data structures that remove locking and blocking ...