<event name="xml_deadlock_report" package="sqlserver" timestamp="2016-08-03T19:09:19.348Z">
  <data name="xml_report">
    <type name="xml" package="package0" />
    <value>
      <deadlock>
        <victim-list>
          <victimProcess id="process28eddf848" />
        </victim-list>
        <process-list>
          <process id="process28eddf848" taskpriority="0" logused="0" waitresource="KEY: 10:72057596664479744 (94c1fc900c7f)" waittime="199" ownerId="5772022993" transactionname="user_transaction" lasttranstarted="2016-08-03T19:09:19.140" XDES="0xa2c7a03b0" lockMode="U" schedulerid="16" kpid="5264" status="suspended" spid="147" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-08-03T19:09:19.140" lastbatchcompleted="2016-08-03T19:09:19.130" lastattention="1900-01-01T00:00:00.130" clientapp=".Net SqlClient Data Provider" hostname="SERVER01" hostpid="22176" loginname="DOMAIN\user" isolationlevel="serializable (4)" xactid="5772022993" currentdb="10" lockTimeout="4294967295" clientoption1="671219744" clientoption2="128056">
            <executionStack>
              <frame procname="extremereach.AdServing.usp_MergeVideoAssets" line="11" stmtstart="482" stmtend="3474" sqlhandle="0x03000a00204159661a4bbb0057a6000001000000000000000000000000000000000000000000000000000000">
                MERGE INTO TargetTable WITH(HOLDLOCK) AS [target]
                USING @dataToMerge AS [source]
                ON [source].KeyPart_1 = [target].KeyPart_1 AND
                [source].KeyPart_2 = [target].KeyPart_2
                WHEN NOT MATCHED THEN
                INSERT(Data, KeyPart_1, KeyPart_2)
                VALUES([source].Data, [source].KeyPart_1, [source].KeyPart_2)
                WHEN MATCHED THEN
                UPDATE SET [target].Data = [source].Data,
                [target].KeyPart_1 = [source].KeyPart_1,
                [target].KeyPart_2 = [source].KeyPart_2;
              </frame>
            </executionStack>
            <inputbuf>
              Proc [Database Id = 10 Object Id = 1717125408]
            </inputbuf>
          </process>
          <process id="process3889b2a4e8" taskpriority="0" logused="0" waitresource="OBJECT: 10:38499416:15 " waittime="199" ownerId="5772022992" transactionname="user_transaction" lasttranstarted="2016-08-03T19:09:19.140" XDES="0x524c8543b0" lockMode="X" schedulerid="11" kpid="5380" status="suspended" spid="468" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2016-08-03T19:09:19.140" lastbatchcompleted="2016-08-03T19:09:19.130" lastattention="2016-08-03T19:07:37.690" clientapp=".Net SqlClient Data Provider" hostname="SERVER02" hostpid="16592" loginname="DOMAIN\user" isolationlevel="serializable (4)" xactid="5772022992" currentdb="10" lockTimeout="4294967295" clientoption1="671219744" clientoption2="128056">
            <executionStack>
              <frame procname="extremereach.AdServing.usp_MergeVideoAssets" line="11" stmtstart="482" stmtend="3474" sqlhandle="0x03000a00204159661a4bbb0057a6000001000000000000000000000000000000000000000000000000000000">
                MERGE INTO TargetTable WITH(HOLDLOCK) AS [target]
                USING @dataToMerge AS [source]
                ON [source].KeyPart_1 = [target].KeyPart_1 AND
                [source].KeyPart_2 = [target].KeyPart_2
                WHEN NOT MATCHED THEN
                INSERT(Data, KeyPart_1, KeyPart_2)
                VALUES([source].Data, [source].KeyPart_1, [source].KeyPart_2)
                WHEN MATCHED THEN
                UPDATE SET [target].Data = [source].Data,
                [target].KeyPart_1 = [source].KeyPart_1,
                [target].KeyPart_2 = [source].KeyPart_2;
              </frame>
            </executionStack>
            <inputbuf>
              Proc [Database Id = 10 Object Id = 1717125408]
            </inputbuf>
          </process>
        </process-list>
        <resource-list>
          <keylock hobtid="72057596664479744" dbid="10" objectname="TargetTable" indexname="AK_TargetTable_NaturalKey" id="lock253a8f2080" mode="U" associatedObjectId="72057596664479744">
            <owner-list>
              <owner id="process3889b2a4e8" mode="U" />
            </owner-list>
            <waiter-list>
              <waiter id="process28eddf848" mode="U" requestType="wait" />
            </waiter-list>
          </keylock>
          <objectlock lockPartition="15" objid="38499416" subresource="FULL" dbid="10" objectname="TargetTable" id="lock2a8cc13a00" mode="IX" associatedObjectId="38499416">
            <owner-list>
              <owner id="process28eddf848" mode="IX" />
            </owner-list>
            <waiter-list>
              <waiter id="process3889b2a4e8" mode="X" requestType="wait" />
            </waiter-list>
          </objectlock>
        </resource-list>
      </deadlock>
    </value>
  </data>
</event>