FIX: All data goes to deltastores when you bulk load data into a clustered columnstore index under memory pressure

Symptoms

When you bulk load data into a clustered columnstore index under memory pressure in Microsoft SQL Server 2016, all the data is inserted into the deltastores, and the Log Optimization can't be used. Therefore, the operation takes a longer time to be completed. If SQL Server restarts in that situation, it may take a long time for SQL Server to recover the database after the restart.

Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest 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 that Microsoft uses to describe software updates.
Vlastnosti

ID článku: 3174073 – Posledná kontrola: 25. 7. 2016 – Revízia: 1

Pripomienky