Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inNote
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.