FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016

Applies to: SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise

Symptoms


When you execute parallel queries on a database that has Snapshot Isolation enabled in Microsoft SQL Server 2016, then a Latch contention may occur on the Latch NESTING_FULL_TRANSACTION.
Similarly, Latch Contention may also occur when you execute parallel queries on a readable secondary replica of Always on Availability Groups.
This may cause performance degradation due to high wait times on the latch NESTING_FULL_TRANSACTION.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

Cumulative Update 4 for SQL Server 2016

Cumulative Update 1 for SQL Server 2016 SP1

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.