Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


If you have a workload that uses many memory-optimized table types in Microsoft SQL Server 2017 on Linux, you may experience excessive PREMPTIVE_OS_CREATEDIRECTORY waits during compilation or recompilation of memory-optimized table types.

This issue can also occur when you deploy scripts that create many memory-optimized tables or procedures or during recovery of a database that has many memory optimized tables.


This fix is included in Cumulative Update 2 for SQL Server 2017.

Important After you install this update, you must enable trace flag 9944 to enable this fix. To enable trace flag 9944, see Trace Flags (Transact-SQL).

About SQL Server 2017 builds

Each new build for SQL Server 2017 contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for SQL Server 2017.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!