Titlebook: Expert SQL Server in-Memory OLTP; Dmitri Korotkevitch Book 20151st edition Dmitri Korotkevitch 2015

minimal

https://doi.org/10.1007/978-3-642-57060-5This appendix provides an overview of nonclustered index internal operations, such as page splitting and page merging.

thwart

https://doi.org/10.1007/978-3-642-29494-5SQL Server persists data from durable memory-optimized tables in checkpoint file pairs. This appendix demonstrates how to analyze their states using the . view and shows the state transitions through the CFP lifetime.

prostatitis

Hang Yu,Zishuo Huang,Yiqun Pan,Weiding LongThis appendix discusses several SQL Server 2014 tools that help with In-Memory OLTP migration.

Asperity

Why In-Memory OLTP?,This introductory chapter explains the importance of in-memory databases and the problems they address. It provides an overview of the Microsoft In-Memory OLTP implementation (code name .) and its design goals. Finally, this chapter discusses the high-level architecture of the In-Memory OLTP Engine and how it is integrated into SQL Server.

Dignant

Memory-Optimized Tables,This chapter discusses memory-optimized tables in detail. It shows how memory-optimized tables store their data and how SQL Server accesses them. It covers the format of the data rows in memory-optimized tables and talks about the process of native compilation.

Certainty

CAMEO

Garbage Collection,This chaptercovers the garbage collection process used in the In-Memory OLTP Engine. It provides an overview of the various components involved in garbage collection and demonstrates how they interact with each other.

大酒杯

Memory Pointers Management,This chapter explains how SQL Server works with memory pointers that link In-Memory OLTP objects together.

STEER

Page Splitting and Page Merging in Nonclustered Indexes,This appendix provides an overview of nonclustered index internal operations, such as page splitting and page merging.

組裝