CHAPTER

21

In-Memory OLTP

In This Chapter

•   Memory-Optimized Tables

•   Row and Index Storage

•   In-Memory OLTP and Concurrency Control

•   Accessing the Content of Memory-Optimized Tables

•   Editing Information Concerning In-Memory Objects

•   Tools for In-Memory OLTP

As previously discussed in Chapter 15, the Database Engine uses disk-oriented storage structures to store tables’ rows. This means that all rows are stored on pages and are brought into memory as needed. (A page is a unit of storage that is moved from a disk to memory and back.) When a page is brought into memory, it must be locked before it can be accessed by an application that requests data on that page. Such locks may require thousands of instructions even when the ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial