SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool
Published Mar 01 2022 09:28 AM 848 Views
Microsoft
Moved from: bobsql.com

 

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.

Co-Authors
Version history
Last update:
‎Mar 01 2022 09:28 AM
Updated by: