Название: SQL Server Internals: In-Memory OLTP
Автор: Kalen Delaney
Издательство: Simple Talk Publishing
ISBN: 978-1-910035-19-1
Год: 2017
Страниц: 201
Язык: английский
Формат: pdf (true), djvu
Размер: 10.18 MB

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.

In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.

The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided.

Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, but Hekaton’s internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered.

In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.

Kalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.