Blog Post

SQL Server Support Blog
1 MIN READ

SQL 2016 - It Just Runs Faster: In-Memory Optimized Database Worker Pool

mssql-support's avatar
mssql-support
Former Employee
Jan 16, 2019
First published on MSDN on May 10, 2016

SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities.  Prior to SQL Server 2016, increasing the size of the pool required you to enable a startup trace flag.

SQL Server 2016 removed the trace flag and updated the design to dynamically adjust the size of the In-Memory Optimized Database worker pool as needed.

'It Just Runs Faster' - SQL Server 2016 dynamically adjusts the In-Memory Optimized worker pool to maximize scalability and performance.

Bob Dorr - Principal SQL Server Software Engineer

Nitin Verma - Senior SQL Server Software Engineer

Updated Jan 16, 2019
Version 2.0
No CommentsBe the first to comment