Sure, what ias throwing me of is that is that the dead locks are between S locks and X locks. All Key locks by the way. Seems like MERGE is not using the version store to read the data but instead tried to take a shared lock.Sure, what ias throwing me of is that is that the dead locks are between S locks and X locks. All Key locks by the way. Seems like MERGE is not using the version store to read the data but instead tried to take a shared lock.

foreign keys?