sql server交换事件引起的死锁

【1】交换事件死锁

【1.0】交换事件等待描述

官网：https://docs.microsoft.com/zh-cn/sql/relational-databases/system-dynamic-management-views/sys-dm-os-waiting-tasks-transact-sql?view=sql-server-ver15

并行查询资源所有者：

  • exchangeEvent id = {Port |Pipe} <hex-address> WaitType = <exchange-wait-type><exchange-node-id>

Exchange-wait-type:

  • e_waitNone

  • e_waitPipeNewRow

  • e_waitPipeGetRow

  • e_waitSynchronizeConsumerOpen

  • e_waitPortOpen

  • e_waitPortClose

【1.1】简单的交换事件

　　　

 

xml

<deadlock>
 <victim-list>
  <victimProcess id="process35eea49468" />
 </victim-list>
 <process-list>
  <process id="process35eea49468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:906029 " waittime="3638" ownerId="58035516968" transactionname="UPDATE" lasttranstarted="2021-05-20T16:37:12.330" XDES="0x4790813900" lockMode="U" schedulerid="29" kpid="8788" status="suspended" spid="531" sbid="0" ecid="40" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:37:12.330" lastbatchcompleted="2021-05-20T16:37:12.327" lastattention="1900-01-01T00:00:00.327" hostname="10.20.50.17" hostpid="41914" isolationlevel="read committed (2)" xactid="58035516968" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="334" sqlhandle="0x0200000057005d05d31c646c57b769e56501a27497b83b640000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="210" sqlhandle="0x020000000fb15723b388abda95a2ba6e36964d8a3065f8180000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+100,SpendTime=SpendTime+354,Win=Win+1 where CustomerID='黄陂秋月' and JF&gt;=281800   </inputbuf>
  </process>
  <process id="process43d64608c8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:906029 " waittime="1912" ownerId="58035515543" transactionname="UPDATE" lasttranstarted="2021-05-20T16:37:11.480" XDES="0x519c052fa0" lockMode="U" schedulerid="6" kpid="9716" status="suspended" spid="502" sbid="0" ecid="3" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:37:11.467" lastbatchcompleted="2021-05-20T16:37:11.283" lastattention="1900-01-01T00:00:00.283" hostname="10.20.50.17" hostpid="1772" isolationlevel="read committed (2)" xactid="58035515543" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="348" sqlhandle="0x020000004f8e522cc62691cdadeb1d9b69b091459d5eaa810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="208" sqlhandle="0x02000000f6ff6e0f8ecdcc3fe6e738f43191b86b5466ac170000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+-300,SpendTime=SpendTime+210,Lost=Lost+1 where CustomerID='兰官' and JF&gt;=9000   </inputbuf>
  </process>
  <process id="process35edb01088" taskpriority="0" logused="10000" waittime="1904" schedulerid="44" kpid="1460" status="suspended" spid="502" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-20T16:37:11.467" lastbatchcompleted="2021-05-20T16:37:11.283" lastattention="1900-01-01T00:00:00.283" hostname="10.20.50.17" hostpid="1772" loginname="agdbsvrnew" isolationlevel="read committed (2)" xactid="58035515543" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="348" sqlhandle="0x020000004f8e522cc62691cdadeb1d9b69b091459d5eaa810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="208" sqlhandle="0x02000000f6ff6e0f8ecdcc3fe6e738f43191b86b5466ac170000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+-300,SpendTime=SpendTime+210,Lost=Lost+1 where CustomerID='兰官' and JF&gt;=9000   </inputbuf>
  </process>
 </process-list>
 <resource-list>
  <pagelock fileid="1" pageid="906029" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock51fbc3b780" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35edb01088" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35eea49468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="906029" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock51fbc3b780" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35eea49468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process43d64608c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <exchangeEvent id="Pipe31a9df8700" WaitType="e_waitPipeGetRow" nodeId="3">
   <owner-list>
    <owner id="process43d64608c8" />
   </owner-list>
   <waiter-list>
    <waiter id="process35edb01088" />
   </waiter-list>
  </exchangeEvent>
 </resource-list>
</deadlock>

 

【1.2】较为复杂的交换事件

看到脑壳都是晕的

　　

 

 xml

<deadlock>
 <victim-list>
  <victimProcess id="process35efb39468" />
 </victim-list>
 <process-list>
  <process id="process35efb39468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:902626 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35eceae4c0" lockMode="U" schedulerid="19" kpid="8140" status="suspended" spid="372" sbid="0" ecid="19" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef072ca8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:905056 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x334405b900" lockMode="U" schedulerid="12" kpid="6636" status="suspended" spid="372" sbid="0" ecid="3" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef0188c8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:833860 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x34689cadc0" lockMode="U" schedulerid="1" kpid="7780" status="suspended" spid="372" sbid="0" ecid="4" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35edb01848" taskpriority="0" logused="0" waitresource="PAGE: 7:1:78416 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x42f6355900" lockMode="U" schedulerid="44" kpid="8216" status="suspended" spid="372" sbid="0" ecid="35" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35eea69468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:903112 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x420043b900" lockMode="U" schedulerid="33" kpid="9120" status="suspended" spid="372" sbid="0" ecid="33" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process40562e1468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:903190 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x3502667900" lockMode="U" schedulerid="29" kpid="8788" status="suspended" spid="372" sbid="0" ecid="30" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb508c8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:821462 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x43a77dd900" lockMode="U" schedulerid="22" kpid="5520" status="suspended" spid="372" sbid="0" ecid="27" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35eea01848" taskpriority="0" logused="0" waitresource="PAGE: 7:1:905867 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x32c421d900" lockMode="U" schedulerid="28" kpid="11608" status="suspended" spid="372" sbid="0" ecid="25" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef03b468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:904408 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35ec7f7120" lockMode="U" schedulerid="5" kpid="8584" status="suspended" spid="372" sbid="0" ecid="8" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process349c344ca8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:775747 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x350a41c040" lockMode="U" schedulerid="16" kpid="9960" status="suspended" spid="372" sbid="0" ecid="23" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef04b468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:903598 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35ec7ff8a0" lockMode="U" schedulerid="7" kpid="9076" status="suspended" spid="372" sbid="0" ecid="10" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb31088" taskpriority="0" logused="0" waitresource="PAGE: 7:1:902788 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35eceaa4c0" lockMode="U" schedulerid="18" kpid="3684" status="suspended" spid="372" sbid="0" ecid="21" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb59c28" taskpriority="0" logused="0" waitresource="PAGE: 7:1:1889200 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35ee738940" lockMode="U" schedulerid="23" kpid="9388" status="suspended" spid="372" sbid="0" ecid="20" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process32fee484e8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:903922 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35e0a45c00" lockMode="U" schedulerid="30" kpid="2344" status="suspended" spid="372" sbid="0" ecid="29" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb79c28" taskpriority="0" logused="0" waitresource="PAGE: 7:1:902464 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x4c13961900" lockMode="U" schedulerid="27" kpid="7848" status="suspended" spid="372" sbid="0" ecid="18" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef053088" taskpriority="0" logused="0" waitresource="PAGE: 7:1:903760 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35ece824c0" lockMode="U" schedulerid="8" kpid="7860" status="suspended" spid="372" sbid="0" ecid="11" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process352c90c8c8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:904246 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x4c6645b900" lockMode="U" schedulerid="11" kpid="2296" status="suspended" spid="372" sbid="0" ecid="13" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef05b468" taskpriority="0" logused="0" waitresource="PAGE: 7:1:905380 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x35ece86940" lockMode="U" schedulerid="9" kpid="6356" status="suspended" spid="372" sbid="0" ecid="39" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb41c28" taskpriority="0" logused="0" waitresource="PAGE: 7:1:901978 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x335ee4b900" lockMode="U" schedulerid="20" kpid="12116" status="suspended" spid="372" sbid="0" ecid="14" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb60ca8" taskpriority="0" logused="0" waitresource="PAGE: 7:1:1579016 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x32fd249900" lockMode="U" schedulerid="24" kpid="11436" status="suspended" spid="372" sbid="0" ecid="15" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35efb69848" taskpriority="0" logused="0" waitresource="PAGE: 7:1:902139 " waittime="2323" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x30ff56f900" lockMode="U" schedulerid="25" kpid="7060" status="suspended" spid="372" sbid="0" ecid="16" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process3540c30108" taskpriority="0" logused="0" waitresource="PAGE: 7:1:906029 " waittime="2319" ownerId="58033837160" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:32.057" XDES="0x313c621900" lockMode="U" schedulerid="43" kpid="7016" status="suspended" spid="372" sbid="0" ecid="40" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:32.060" lastbatchcompleted="2021-05-20T16:17:32.060" lastattention="1900-01-01T00:00:00.060" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837160" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="102" stmtend="344" sqlhandle="0x020000006fa3fc323b7d20ff6da2e89ec788fd34cf7c04810000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="220" sqlhandle="0x0200000062bc602ca79d2fed6f1d895e98028eb385a678aa0000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+300,SpendTime=SpendTime+143,Win=Win+1 where CustomerID='W02_f78768' and JF&gt;=16100   </inputbuf>
  </process>
  <process id="process35ef019848" taskpriority="0" logused="420" waitresource="PAGE: 7:1:905056 " waittime="1761" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x34689cb0c0" lockMode="U" schedulerid="1" kpid="5924" status="suspended" spid="419" sbid="0" ecid="33" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35ef04b088" taskpriority="0" logused="420" waitresource="PAGE: 7:1:903922 " waittime="1795" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x35ec7ffba0" lockMode="U" schedulerid="7" kpid="8048" status="suspended" spid="419" sbid="0" ecid="5" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35efb41088" taskpriority="0" logused="420" waitresource="PAGE: 7:1:905380 " waittime="1805" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x335ee4bc00" lockMode="U" schedulerid="20" kpid="9692" status="suspended" spid="419" sbid="0" ecid="9" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process43d64608c8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:903598 " waittime="1860" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x519c052fa0" lockMode="U" schedulerid="6" kpid="4340" status="suspended" spid="419" sbid="0" ecid="4" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process349c3448c8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:904246 " waittime="1758" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x350a41c340" lockMode="U" schedulerid="16" kpid="9796" status="suspended" spid="419" sbid="0" ecid="29" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process40562e08c8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:902464 " waittime="2234" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x3502667c00" lockMode="U" schedulerid="29" kpid="9928" status="suspended" spid="419" sbid="0" ecid="16" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process4c2fb46108" taskpriority="0" logused="420" waitresource="PAGE: 7:1:903190 " waittime="1862" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x35ec7eaf40" lockMode="U" schedulerid="2" kpid="10080" status="suspended" spid="419" sbid="0" ecid="3" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35edb21468" taskpriority="0" logused="420" waitresource="PAGE: 7:1:78416 " waittime="1962" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x3f55c11420" lockMode="U" schedulerid="48" kpid="8204" status="suspended" spid="419" sbid="0" ecid="20" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35efb78ca8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:903760 " waittime="1835" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x4c13961c00" lockMode="U" schedulerid="27" kpid="11080" status="suspended" spid="419" sbid="0" ecid="13" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process31c5649088" taskpriority="0" logused="420" waitresource="PAGE: 7:1:906029 " waittime="1675" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x34288ebc00" lockMode="U" schedulerid="10" kpid="9284" status="suspended" spid="419" sbid="0" ecid="7" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35ef06b468" taskpriority="0" logused="420" waitresource="PAGE: 7:1:901978 " waittime="2319" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x4c6645bc00" lockMode="U" schedulerid="11" kpid="9992" status="suspended" spid="419" sbid="0" ecid="8" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process3475cac4e8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:904408 " waittime="1753" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x32c421dc00" lockMode="U" schedulerid="28" kpid="7416" status="suspended" spid="419" sbid="0" ecid="27" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35ef07aca8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:833860 " waittime="1967" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x5373c25900" lockMode="U" schedulerid="13" kpid="9384" status="suspended" spid="419" sbid="0" ecid="1" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35efb19088" taskpriority="0" logused="420" waitresource="PAGE: 7:1:905867 " waittime="1799" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x35ece9e7c0" lockMode="U" schedulerid="15" kpid="10908" status="suspended" spid="419" sbid="0" ecid="28" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35e20b1848" taskpriority="0" logused="420" waitresource="PAGE: 7:1:1579016 " waittime="2071" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x35ecee3120" lockMode="U" schedulerid="32" kpid="10220" status="suspended" spid="419" sbid="0" ecid="38" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process33b5dc1c28" taskpriority="0" logused="420" waitresource="PAGE: 7:1:821462 " waittime="1987" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x42f6355c00" lockMode="U" schedulerid="44" kpid="1460" status="suspended" spid="419" sbid="0" ecid="17" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35efb29c28" taskpriority="0" logused="420" waitresource="PAGE: 7:1:902626 " waittime="2166" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x35ecea67c0" lockMode="U" schedulerid="17" kpid="7720" status="suspended" spid="419" sbid="0" ecid="35" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process34c2c6cca8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:775747 " waittime="2046" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x32bf1e7c00" lockMode="U" schedulerid="21" kpid="9596" status="suspended" spid="419" sbid="0" ecid="26" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process33c22fcca8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:902788 " waittime="2114" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x35e20dbc00" lockMode="U" schedulerid="31" kpid="7036" status="suspended" spid="419" sbid="0" ecid="32" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process35ce5b0108" taskpriority="0" logused="420" waitresource="PAGE: 7:1:902139 " waittime="2259" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x420043bc00" lockMode="U" schedulerid="33" kpid="7404" status="suspended" spid="419" sbid="0" ecid="25" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process4cb212e8c8" taskpriority="0" logused="420" waitresource="PAGE: 7:1:1889200 " waittime="2046" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x43a77ddc00" lockMode="U" schedulerid="22" kpid="8716" status="suspended" spid="419" sbid="0" ecid="14" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process40c4470108" taskpriority="0" logused="420" waitresource="PAGE: 7:1:903112 " waittime="1926" ownerId="58033837011" transactionname="UPDATE" lasttranstarted="2021-05-20T16:17:31.973" XDES="0x3343481c00" lockMode="U" schedulerid="46" kpid="2252" status="suspended" spid="419" sbid="0" ecid="18" priority="0" trancount="0" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
  <process id="process34c2c6c4e8" taskpriority="0" logused="10000" waittime="1671" schedulerid="21" kpid="3504" status="suspended" spid="419" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-20T16:17:31.980" lastbatchcompleted="2021-05-20T16:17:31.677" lastattention="1900-01-01T00:00:00.677" hostname="10.20.50.17" hostpid="4082" loginname="agdbsvrnew" isolationlevel="read committed (2)" xactid="58033837011" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
   <executionStack>
    <frame procname="adhoc" line="1" stmtstart="92" stmtend="342" sqlhandle="0x02000000bd9ad70fca35149969398484a95728ef4bea90710000000000000000000000000000000000000000">
unknown    </frame>
    <frame procname="adhoc" line="1" stmtend="216" sqlhandle="0x0200000018c49e00b3b76c0be745b0bfa49362f8310cbc960000000000000000000000000000000000000000">
unknown    </frame>
   </executionStack>
   <inputbuf>
update test set JF=JF+0,SpendTime=SpendTime+105,Peace=Peace+1 where CustomerID='泥河地主4' and JF&gt;=139900   </inputbuf>
  </process>
 </process-list>
 <resource-list>
  <pagelock fileid="1" pageid="902626" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock408204cb80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process33c22fcca8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb39468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="905056" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock321bf75780" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef072ca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="833860" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock31977c0c00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35edb21468" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef0188c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="78416" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock440bc44300" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35edb01848" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903112" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock3260229d00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process4c2fb46108" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35eea69468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903190" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4cce1d1f80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process40562e1468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="821462" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock3f6e802080" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef07aca8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb508c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="905867" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock31571fc780" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process31c5649088" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35eea01848" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="904408" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock31a3426b00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef03b468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="775747" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4d0d8ad080" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process33b5dc1c28" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process349c344ca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903598" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4dd8021900" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb78ca8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef04b468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902788" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock44c8c84e80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb31088" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="1889200" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock30f1666c80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb59c28" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903922" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock448a02ef80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process32fee484e8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902464" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock43f180ef00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb29c28" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb79c28" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903760" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock52fd41b280" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef04b088" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef053088" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="904246" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4430720500" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process3475cac4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process352c90c8c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="905380" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock342bf29200" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef05b468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="901978" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock32a7e81700" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ce5b0108" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb41c28" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="1579016" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock420c419c00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb60ca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902139" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4a1305ac80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb69848" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="906029" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock3376e3da80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process34c2c6c4e8" mode="U" />
   </owner-list>
   <waiter-list>
    <waiter id="process3540c30108" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="905056" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock321bf75780" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef072ca8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef019848" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903922" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock448a02ef80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process32fee484e8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef04b088" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="905380" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock342bf29200" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef05b468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb41088" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903598" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4dd8021900" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef04b468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process43d64608c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="904246" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4430720500" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process352c90c8c8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process349c3448c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902464" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock43f180ef00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb79c28" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process40562e08c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903190" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4cce1d1f80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process40562e1468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process4c2fb46108" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="78416" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock440bc44300" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35edb01848" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35edb21468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903760" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock52fd41b280" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef053088" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb78ca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="906029" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock3376e3da80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process3540c30108" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process31c5649088" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="901978" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock32a7e81700" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb41c28" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef06b468" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="904408" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock31a3426b00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef03b468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process3475cac4e8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="833860" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock31977c0c00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35ef0188c8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ef07aca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="905867" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock31571fc780" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35eea01848" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb19088" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="1579016" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock420c419c00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb60ca8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35e20b1848" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="821462" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock3f6e802080" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb508c8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process33b5dc1c28" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902626" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock408204cb80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb39468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35efb29c28" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="775747" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4d0d8ad080" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process349c344ca8" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process34c2c6cca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902788" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock44c8c84e80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb31088" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process33c22fcca8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="902139" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock4a1305ac80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb69848" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process35ce5b0108" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="1889200" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock30f1666c80" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35efb59c28" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process4cb212e8c8" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <pagelock fileid="1" pageid="903112" dbid="7" subresource="FULL" objectname="a.dbo.test" id="lock3260229d00" mode="U" associatedObjectId="72057594052935680">
   <owner-list>
    <owner id="process35eea69468" mode="U" requestType="wait" />
   </owner-list>
   <waiter-list>
    <waiter id="process40c4470108" mode="U" requestType="wait" />
   </waiter-list>
  </pagelock>
  <exchangeEvent id="Pipe310c9f8700" WaitType="e_waitPipeGetRow" nodeId="3">
   <owner-list>
    <owner id="process35ef07aca8" />
    <owner id="process35ef019848" />
    <owner id="process4c2fb46108" />
    <owner id="process43d64608c8" />
    <owner id="process35ef04b088" />
    <owner id="process31c5649088" />
    <owner id="process35ef06b468" />
    <owner id="process35efb41088" />
    <owner id="process35efb78ca8" />
    <owner id="process35efb29c28" />
    <owner id="process349c3448c8" />
    <owner id="process35efb19088" />
    <owner id="process3475cac4e8" />
    <owner id="process34c2c6cca8" />
    <owner id="process4cb212e8c8" />
    <owner id="process40562e08c8" />
    <owner id="process33c22fcca8" />
    <owner id="process35e20b1848" />
    <owner id="process35ce5b0108" />
    <owner id="process33b5dc1c28" />
    <owner id="process35edb21468" />
    <owner id="process40c4470108" />
   </owner-list>
   <waiter-list>
    <waiter id="process34c2c6c4e8" />
   </waiter-list>
  </exchangeEvent>
 </resource-list>
</deadlock>
deadlock xml

 

【2】原因分析与解决办法

超锅说的，记下来分析

描述1：这个一般说明执行语句走了并行，线程之间产生了等待

　　并行性死锁，交换等待类型（Parallel query worker thread was involved in a deadlock）

解决办法

指定并行核心数，或者调整语法，或者调整表结构索引

指定并行核心数能解决的官方有说明，例子就是取单双，如下：

SELECT ProductID, OrderQty, SUM(LineTotal) AS Total  
FROM Sales.SalesOrderDetail  
WHERE UnitPrice < $5.00  
GROUP BY ProductID, OrderQty  
ORDER BY ProductID, OrderQty  
OPTION (MAXDOP 2);

 

描述2：还有一种情况，就是高并发

　　本来一个并行的操作应该是多个线程分配了不同的工作，这个就是并行度，如果其中一个或者多个线程比较慢，就会产生cxpacket等待，这种就叫同步查询处理器交换迭代器，因为0号线程会等待所有结果出来再聚合返回；

　　但是如果同步查询处理器交换迭代器的过程中，各线程发生了资源的争用，就会出现exchange等待；就撞车、追尾了

解决办法

　　　　如上图复杂的交换事件问题，是因为高并发update引起的

　　　　看情况调整语法、调整表结构索引

　　　　然后还不行，则在存储过程中加事务、然后在与update相同条件的select 中写上 with updlock，可能还需要 holdlock

SELECT ProductID, OrderQty, SUM(LineTotal) AS Total  
FROM Sales.SalesOrderDetail with(updlock,holdlock)
WHERE UnitPrice < 5.00  
GROUP BY ProductID, OrderQty  
ORDER BY ProductID, OrderQty  
OPTION (MAXDOP 2);

【3】参考文档

（1）查询提示 option

（maxdop）

https://docs.microsoft.com/zh-cn/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver15

（2）查询中的表提示

https://docs.microsoft.com/zh-cn/sql/t-sql/queries/hints-transact-sql-table?view=sql-server-ver15

（3）连接提示

https://docs.microsoft.com/zh-cn/sql/t-sql/queries/hints-transact-sql-join?view=sql-server-ver15

　

posted @ 2021-05-21 11:23  郭大侠1  阅读(996)  评论(0)  编辑  收藏  举报