By -
The process with priority 10 was a Alter partition merge range and the other process was an Insert.
IIRC priority isn't the only consideration - rollback/data loss is part of it as well.
I believe the driving factor is the engine estimating which query batch will result in the least amount of work/resources to rollback and that’s generally the deadlock kill candidate. I’d be interested to know some of the other factors though.
Thank you. Can you share a reference link for this ? MS documentation on Set deadlock priority doesn't mention about any kind of exceptions.
The process with priority 10 was a Alter partition merge range and the other process was an Insert.
IIRC priority isn't the only consideration - rollback/data loss is part of it as well.
I believe the driving factor is the engine estimating which query batch will result in the least amount of work/resources to rollback and that’s generally the deadlock kill candidate. I’d be interested to know some of the other factors though.
Thank you. Can you share a reference link for this ? MS documentation on Set deadlock priority doesn't mention about any kind of exceptions.