SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this overview, we discuss the user scenarios and the hardware trends, such as decreasing memory cost, many-core processors, and stalling CPU clock rate that prompted the key architectural pillars of memory optimization, no lock/latch concurrency control, and native compilation. We also cover how in-memory OLTP is integrated with the rest of SQL Server.


Microsoft CSS Team