You're reading from SQL Server 2019 Administrator's Guide - Second Edition

Product type Book

Published in Sep 2020

Publisher Packt

ISBN-13 9781789954326

Pages 522 pages

Edition 2nd Edition

Languages

SQL

Concepts

Database Administration

Authors (2):

Marek Chmel

Vladimír Mužný

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Provisioning the SQL Server Environment

2. Chapter 1: Setting Up SQL Server 2019

3. Chapter 2: Keeping Your SQL Server Environment Healthy

4. Section 2: Server and Database Maintenance

5. Chapter 3: Implementing Backup and Recovery

6. Chapter 4: Securing Your SQL Server

7. Chapter 5: Working with Disaster Recovery Options

8. Chapter 6: Indexing and Performance

9. Section 3: High Availability and the Cloud with SQL Server 2019

10. Chapter 7: Planning Migration and Upgrade

11. Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019

12. Chapter 9: Configuring Always On High Availability Features

13. Chapter 10: In-Memory OLTP – Why and How to Use it

14. Chapter 11: Combining SQL Server 2019 with Azure

15. Chapter 12: Taming Big Data with SQL Server

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

In-Memory OLTP architecture

In-Memory OLTP is a feature of SQL Server that offers the option to create memory-optimized tables and natively compiled modules just like stored procedures. In-Memory OLTP utilizes a portion of memory up to a limit set by the given edition of SQL Server (for example, Enterprise Edition). The data of the memory-optimized tables is placed in memory. Transactions working with data in memory-optimized tables are controlled in optimistic row-versioning mode. Both properties – the memory utilization and optimistic transaction control – lead to a throughput in the database of up to 30 times greater. The adoption of In-Memory OLTP is quite easy from a developers's perspective as the development effort is not increased with new syntax. The traditional T-SQL approach has been kept by Microsoft to ease the adoption of the feature. Besides the simplicity of the development effort, In-Memory OLTP brings great performance benefits to the database.

...