This document provides links to information and resources for Microsoft SQL Server 2019 (15.x) or later for Windows and Linux.
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.|
DisclaimerCopyright© kb.pmem.io 2020. All rights reserved.
Copyright© kb.pmem.io 2020. All rights reserved.