This document provides links to information and resources for Microsoft SQL Server 2019 (15.x) or later for Windows and Linux.
- Home: https://www.microsoft.com/en-us/sql-server/sql-server-2019
- Download: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
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
- What’s new in SQL Server 2019 (15.x)
- How to deploy persistent memory in Windows Server using Storage Spaces Direct
- How to configure persistent memory (PMEM) for SQL Server on Linux
- Understand the Hybrid Buffer Pool
- How to add a persisted log buffer to a database
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]