• 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