Home Forums SQL Server 2016 SQL Server 2016 - Administration DeadLock --trying to figure out what resource-list is telling me? RE: DeadLock --trying to figure out what resource-list is telling me?
456789psw
SSCarpal Tunnel
Points: 4728
More actions
May 16, 2018 at 7:17 am
#1990653
Solved!
<SyncPoint> is an indication of an Exchange event. If you run profiler trace with deadlock graph it will clearly show its and exchange dead lock( intra-query parallelism deadlocks). Add MAXDOP 1 and the issue will be resolved