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.
ID članka: 3211646 - posljednja izmjena: 17. sij 2017. - verzija: 5