SQL Server Internals: In-Memory OLTP
Inside the SQL Server 2016 Hekaton Engine
by Kalen Delaney
DescriptionTable of ContentsDetailsHashtagsReport an issue
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. 
Book Description
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.
This open book is licensed strictly for personal or educational use. You can download SQL Server Internals: In-Memory OLTP ebook for free in PDF format (12.5 MB).
Table of Contents
Chapter 1
What's Special About In-Memory OLTP?
Chapter 2
Creating and Accessing In-Memory OLTP Databases and Tables 35
Chapter 3
Row Structure and Multi-Versioning
Chapter 4
Indexes on Memory-Optimized Tables
Chapter 5
Transaction Processing
Chapter 6
Logging, Checkpoint, and Recovery
Chapter 7
Native Compilation of Tables and Native Modules
Chapter 8
SQL Server Support and Manageability
Book Details
Title
SQL Server Internals: In-Memory OLTP
Subject
Computer Science
Publisher
Red Gate
Published
2017
Pages
201
Edition
2
Language
English
ISBN13 Digital
9781910035191
ISBN10 Digital
191003519X
PDF Size
12.5 MB
License
For personal or educational use
Related Books
Microsoft SQL Server is a relational database management system developed by Microsoft. It is an unofficial and free Microsoft SQL Server ebook created for educational purposes. All the content is extracted from Stack Overflow Documentation, which is written by many hardworking individuals at Stack Overflow....
The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.
Too often as deve...
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
Relational databases place heavy demands on their underlying hardware and many of these databases are mission-...
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you fin...
R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it's a rich ecostructure with advanced analytic ...