Delaney Kalen. SQL Server Internals: In-Memory OLTP

Simple Talk Publishing, 2017. — 201 p. — ISBN: 978-1-910035-19-1.This book, SQL Server Internals: In-Memory OLTP is a true gem for modern data developers and data professionals. It contains an unprecedented level of details about the in-memory technology of SQL Server. In my many conversations with customers, I often hear a confusion between the terms "In-Memory" and "Memory-Optimized." Many think that they are one and the same. If you continue reading this book, you will realize the distinction. In-Memory OLTP is a game changer for relational databases, and especially for OLTP systems.Processors are not getting dramatically faster, but the number of cores and the amount of memory is increasing drastically. Machines with terabytes of memory are becoming a commodity. Over the last 30 years, memory prices have dropped by a factor of 10 every 5 years. Both core counts and memory sizes are increasing at an accelerated pace. The majority of OLTP databases fit entirely in 1 TB and even the largest OLTP databases can keep the active working set in memory. A technology that takes advantage of this everchanging hardware landscape is Microsoft's in-memory OLTP.