A data flush task may cause a deadlock condition when queries are executed on a memory-optimized table in SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core


If an ALTER TABLE query on a system-versioned memory-optimized table in SQL Server 2016 when a data flush task is moving records from the in-memory internal buffer to the disk-based history table, a deadlock condition may occur.


The fix for this issue is included in the following cumulative update for SQL Server:


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.