SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine

SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine Front Cover
0 Reviews
2017-10-16
204 pages

Book Description

The 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- stored procedures, that Server has always provided.

Hekaton in-memory data is accessible, transparently, using familiar interfaces such as and SSMS, but Hekaton's internal and capabilities are very different than those of the standard relational engine. Everything you knew about how your 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 . The Hekaton knowledge she provides in this book will help you migrate existing tables or to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.

Book Details

  • Title: SQL Server Internals: In-Memory Oltp: Inside the SQL Server 2016 Hekaton Engine
  • Author:
  • Length: 204 pages
  • Edition: 1
  • Language: English
  • Publisher:
  • Publication Date: 2017-10-16
  • ISBN-10: 1910035203
  • ISBN-13: 9781910035207
Download LinkFormatSize (MB)Upload Date
Download from UsersCloudTrue PDF4.812/31/2018
How to Download? Report Dead Links & Get a Copy