%3CLINGO-SUB%20id%3D%22lingo-sub-318793%22%20slang%3D%22en-US%22%3ESQL%202016%20-%20It%20Just%20Runs%20Faster%3A%20In-Memory%20Optimized%20Database%20Worker%20Pool%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318793%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20May%2010%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3ESQL%20Server%20leverages%20a%20worker%20pool%20for%20the%20In-Memory%20Optimized%20Database%20capabilities.%26nbsp%3B%20Prior%20to%20SQL%20Server%202016%2C%20increasing%20the%20size%20of%20the%20pool%20required%20you%20to%20enable%20a%20startup%20trace%20flag.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3ESQL%20Server%202016%20removed%20the%20trace%20flag%20and%20updated%20the%20design%20to%20dynamically%20adjust%20the%20size%20of%20the%20In-Memory%20Optimized%20Database%20worker%20pool%20as%20needed.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E'It%20Just%20Runs%20Faster'%20%3C%2FSTRONG%3E%20-%20SQL%20Server%202016%20dynamically%20adjusts%20the%20In-Memory%20Optimized%20worker%20pool%20to%20maximize%20scalability%20and%20performance.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EBob%20Dorr%20-%20Principal%20SQL%20Server%20Software%20Engineer%3C%2FP%3E%0A%20%20%3CP%3ENitin%20Verma%20-%20Senior%20SQL%20Server%20Software%20Engineer%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318793%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20May%2010%2C%202016%20SQL%20Server%20leverages%20a%20worker%20pool%20for%20the%20In-Memory%20Optimized%20Database%20capabilities.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318793%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EInMemory%20OLTP%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esql%202016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft
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