SQL Server Internals: In-Memory Oltp

The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is designed from the ground up 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.

SQL Server 2014 的 In-Memory OLTP 引擎（又稱 Hekaton）從頭開始設計，以利用可用的數TB記憶體和高數量的處理核心。它允許我們使用內存優化的表格和索引，以及本地編譯的存儲過程，除了SQL Server一直提供的基於磁盤的表格和索引，以及T-SQL存儲過程。Hekaton內存中的數據可以透明地使用熟悉的界面，如T-SQL和SSMS，但Hekaton的內部行為和功能與標準關聯引擎非常不同。在Hekaton中，您對SQL Server存儲和訪問數據的了解都將有所不同。您對如何處理多個並發進程的理解需要重新考慮。在這本書中，Kalen Delaney解釋了新的In-Memory OLTP引擎的工作原理，數據的存儲和操作方式，以及即使所有數據都存儲在內存中且沒有鎖定或閂鎖，它仍然可以保證所有事務的ACID特性。Kalen從1987年開始就一直在使用SQL Server，專注於查詢性能調優和SQL Server內部。她在這本書中提供的Hekaton內部知識將幫助您將現有的表格或數據庫遷移到Hekaton，並從您的SQL Server應用程序中獲得比您想像的更快的性能。