Data Storage, Logging, and Recovery
Dmitri Korotkevitch · Apress eBooks · 2015
This chapter discusses how In-Memory OLTP stores the data from durable memory-optimized tables on disk. It illustrates the concept of checkpoint file pairs used by SQL Server to persist the data, provides an overview of checkpoint process in In-Memory OLTP, and discusses recovery of memory-optimized data. Finally, this chapter demonstrates how In-Memory OLTP logs the data in a transaction log and why In-Memory OLTP logging is more efficient compared to on-disk tables. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.