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

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



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 that Microsoft uses to describe software updates.
Svojstva

ID članka: 3211646 - posljednja izmjena: 17. sij 2017. - verzija: 5

Povratne informacije