SQL Server Internals: In-Memory OLTP



Download free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney.
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.

Table of contents

  • What's Special About In-Memory OLTP?
  • Creating and Accessing In-Memory OLTP Databases and Tables 35
  • Row Structure and Multi-Versioning
  • Indexes on Memory-Optimized Tables
  • Transaction Processing
  • Logging, Checkpoint, and Recovery
  • Native Compilation of Tables and Native Modules
  • SQL Server Support and Manageability
Pages201
Size12.5 MB
File typePDF
Downloads233
Created2022-02-03
LicenseFor personal or educational use
Author(s) Kalen Delaney
Cover of SQL Server Internals: In-Memory OLTP

Download

  • Graph Databases For Beginners

    Whether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....

  • Tutorial PostgreSQL in pdf

    This course about PostgeSQL is a pdf document intended to beginners who wants to learn the basics of PostgreSQL SBGD....

  • How To Manage a Redis Database

    Download free course How To Manage a Redis Database, pdf file on 95 pages by Mark Drake....

  • SQL Server Backup and Restore

    Download tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....

  • Introduction to Access 2010

    Start to learn Microsoft Access 2010 with this free PDF tutorial and more about new useful features insides including designing databases and queries,training document for download under 24 ....

  • Access 2013 Lab manual

    Download free Microsoft Office Access 2013 file under 115 pages,pdf manual , course tutorial training on pdf by David Murray (University at Buffalo)....

  • Migrating SQL Server Databases to Azure

    Download free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....

  • Microsoft SQL Server Notes for Professionals

    Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community....

  • Learning MySQL

    Download free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL....

  • MySQL Notes for Professionals

    Download free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....