Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2015). Data Storage, Logging, and Recovery. In: Expert SQL Server In-Memory OLTP. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1136-6_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1136-6_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1137-3
Online ISBN: 978-1-4842-1136-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books