SQL Server Internals: In-Memory OLTPКНИГИ » ОС И БД
Название: 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.
Expert SQL Server In-Memory OLTP, 2nd Edition Название: Expert SQL Server In-Memory OLTP, 2nd Edition Автор: Dmitri Korotkevitch Издательство: Apress Год: 2017 Страниц: 304 Формат: PDF Размер: 12...
SQL Server on Linux (+code) Название: SQL Server on Linux (+code) Автор: Jasmin Azemovi? Издательство: Packt Publishing Год: 2017 Страниц: 222 Формат: True PDF, EPUB, AZW3...
Pro SQL Server Internals, 2nd edition Название: Pro SQL Server Internals, 2nd edition Автор: Dmitri Korotkevitch Издательство: Apress Год: 2016 Страниц: 804 Формат: PDF Размер: 51 Mb...
A Memory of Trains: The Boll Weevil and Others Автор: Louis Decimus Rubin Название: A Memory of Trains: The Boll Weevil and Others Издательство: University of South Carolina Press Год: 2000...
Beginning SQL Server for Developers Название: Beginning SQL Server for Developers Автор: Dewson R. Издательство: Apress Год: 2015 Формат: pdf Страниц: 670 Размер: 20 mb Язык:...
Навигация
Вход на сайт
Реклама
SQL Server Internals: In-Memory OLTP 
