BLUE
Profile banner
DH
Daniel Hutmacher
@dhma.ch
Swiss/Swedish, Data Platform MVP. @dhmacher on other platforms. My work: strd.co My blog: sqlsunday.com Call for Data Speakers: @callfordataspeakers.com Data Saturday Stockholm: datasatsto.se I just want to use your SQL Server tonight.
287 followers147 following696 posts
DHdhma.ch

Is there anything else than the MERGE statement in your transaction, like a DDL statement? For what it's worth, I ran into a similar issue, though not on RCSI but with a HOLDLOCK hint, which forced serializable isolation.

How MERGE on two different rows can still deadlock you
How MERGE on two different rows can still deadlock you

I recently ran into a curious deadlock issue. I have a process that performs a lot of updates in a "state" table using multiple, concurrent connections. The business logic in the application guarantee...

1

DHdhma.ch

Also: Does your table have a single clustered index, or are there non-clustered indexes that are affected by the MERGE?

1
Profile banner
DH
Daniel Hutmacher
@dhma.ch
Swiss/Swedish, Data Platform MVP. @dhmacher on other platforms. My work: strd.co My blog: sqlsunday.com Call for Data Speakers: @callfordataspeakers.com Data Saturday Stockholm: datasatsto.se I just want to use your SQL Server tonight.
287 followers147 following696 posts