Microsoft SQL Server 2019

This document provides links to information and resources for Microsoft SQL Server 2019 (15.x) or later for Windows and Linux.

What’s New

SQL Server In-Memory Database technologies leverage modern hardware innovation to deliver unparalleled performance and scale. SQL Server 2019 (15.x) builds on earlier innovations in this area, such as in-memory online transaction processing (OLTP), to unlock a new level of scalability across all your database workloads.

New feature or update	Details
Hybrid buffer pool	New feature of the SQL Server Database Engine where database pages sitting on database files placed on a persistent memory (PMEM) device will be directly accessed when required. See Hybrid buffer pool.
Memory-optimized TempDB metadata	SQL Server 2019 (15.x) introduces a new feature that is part of the In-Memory Database feature family, memory-optimized TempDB metadata, which effectively removes this bottleneck and unlocks a new level of scalability for TempDB heavy workloads. In SQL Server 2019 (15.x), the system tables involved in managing temporary table metadata can be moved into latch-free non-durable memory-optimized tables. See Memory-Optimized TempDB Metadata.
In-Memory OLTP support for Database Snapshot	SQL Server 2019 (15.x) introduces support for creating Database Snapshots of databases that include memory-optimized filegroups.

Documentation

Learning & Training

Microsoft SQL Server 2019: New Features. See Section 1.1 “Improvements to persistent memory” [Lynda]
Microsoft SQL Server 2019: New Features. See Section 1.1 “Improvements to persistent memory” [LinkedIn Learning]
Windows Server 2019 with Intel Optane DC persistent memory - Microsoft Ignite 2018 [YouTube]
How To: Creating a Persistent Log Buffer in SQL 2019 - Data Exposed [YouTube]

Books

Document ID
100000024
Creation Date
2020-03-24