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

Symptoms


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.

Resolution


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


Status


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

References


Learn about the terminology Microsoft uses to describe software updates.