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.
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
- Anonymous
May 12, 2016
Good to hear about this optimisation. You mention 'a worker pool for the In-Memory Optimized Database capabilities'. This is the first I've heard of such a worker pool. I didn't even know about the trace flag for versions prior to SQL 2016. Do do have any papers or postings about this worker pool or the trace flag ? As a DBA I'd like more information about this.Thanks again.