Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL Server 2016 (13.x) contains scalability enhancements to the on-disk storage for memory-optimized tables.
Multiple threads to persist memory-optimized tables
SQL Server 2014 (12.x) had a single offline checkpoint thread that scanned the transaction log for changes to memory-optimized tables and persisted them in checkpoint files (such as data and delta files). In machines with a larger number of cores, the single offline checkpoint thread could fall behind.
In SQL Server 2016 (13.x) and later versions, there are multiple concurrent threads responsible to persist changes to memory-optimized tables.
Multi-threaded recovery
In the previous release of SQL Server, the log apply portion of the recovery operation was single threaded. In SQL Server 2016 (13.x) and later versions, the log apply is multithreaded.
MERGE operation
The MERGE operation is now multithreaded.
Dynamic management views
The DMVs sys.dm_db_xtp_checkpoint_stats and sys.dm_db_xtp_checkpoint_files have been changed significantly.
Storage management
The In-memory OLTP engine continues to use memory-optimized filegroup based on FILESTREAM, but the individual files in the filegroup are decoupled from FILESTREAM. These files are fully managed (such as for create, drop, and garbage collection) by the In-Memory OLTP engine.
Note
DBCC SHRINKFILE isn't supported.