A memory leak occurs when DATA_CONSISTENCY_CHECK is being executed for a system-versioned temporal table in SQL Server 2016

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

Symptoms


When DATA_CONSISTENCY_CHECK is being executed for a system-versioned temporal table and an error occurs on memory allocation, a memory leak in MEMORYCLERK_SOSNODE within the SQL Server engine might occur.

Resolution


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


Workaround


To work around this issue, add the ALTER TABLE clause in your CREATE TABLE statement.

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.