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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.