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

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:


About cumulative updates for SQL Server
About cumulative updates 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.
Proprietăți

ID articol: 3173841 - Ultima examinare: 25 iul. 2016 - Revizie: 1

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core

Feedback