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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3211646 - Last Review: 2017 urt. 17 - Revision: 5