帮忙分析一下这个阻塞的原因

mynamedan 2011-03-21 10:38:45

<blocked-process-report monitorLoop="227435">
<blocked-process>
<process id="processdf5c48" taskpriority="0" logused="424" waitresource="OBJECT: 12:299304276:0 " waittime="5531" ownerId="100485312" transactionname="user_transaction"
lasttranstarted="2011-03-21T08:39:19.607" XDES="0x2ecd0250" lockMode="IX" schedulerid="4" kpid="2016" status="suspended" spid="70" sbid="0" ecid="0" priority="0" transcount="2"
lastbatchstarted="2011-03-21T08:39:19.623" lastbatchcompleted="2011-03-21T08:39:19.607" clientapp=".Net SqlClient Data Provider" hostname="WEBAPP" hostpid="6236" loginname="SSASUserLianQi"
isolationlevel="serializable (4)" xactid="100485312" currentdb="12" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame line="67" stmtstart="3586" stmtend="4750" sqlhandle="0x03000c00e91ad85e5088b700a29e00000100000000000000"/>
<frame line="1" stmtstart="654" sqlhandle="0x01000c00dc2e673b303d6c27000000000000000000000000"/>
<frame line="1" sqlhandle="0x000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@p0 uniqueidentifier,@p1 int,@p2 uniqueidentifier,@p3 int,@p4 datetime,@p5 int,@p6 int,@p7 int,@p8 int,@p9 decimal(13,4),@p10 decimal(13,4),@p11 nvarchar(3),@p12 int,@p13 nvarchar(4000),@p14
nvarchar(4000),@p15 nvarchar(2),@p16 int,@p17 nvarchar(2),@p18 int,@p19 nvarchar(16),@p20 nvarchar(30) output,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[PROC_MD_SAVEup_HUIDAN] @HUIDAN_ID = @p0,
@MD_ID = @p1, @DINGDAN_ID = @p2, @KH_ID = @p3, @YeWuRiQi = @p4, @PeiSongYuanID = @p5, @ShouKuanRenID = @p6, @YeWuYuanID = @p7, @FuKuanFangShi = @p8, @YingShouJinE = @p9, @ShiShouJinE = @p10, @LuRuRen = @p11,
@DanJuLeiXingID = @p12, @ZiBianHao = @p13, @BeiZhu = @p14, @HD_ChaoShi = @p15, @KH_DiZhi = @p16, @HD_dhr = @p17, @HD_DHMD_ID = @p18, @HD_DanHao = @p19, @TAG = @p20 OUTPUT </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="suspended" waitresource="12:1:1895929" waittime="15" spid="61" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2011-03-21T08:39:17.687"
lastbatchcompleted="2011-03-21T08:39:17.687" clientapp=".Net SqlClient Data Provider" hostname="WEBAPP" hostpid="6236" loginname="SSASUserLianQi" isolationlevel="serializable (4)" xactid="100484786"
currentdb="12" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame line="29" stmtstart="2206" sqlhandle="0x020000002023281e38246cc66c56eacbdf128b69660777e3"/>
<frame line="1" sqlhandle="0x0400ff7fbe80662601000000000000000000000000000000"/>
<frame line="510" stmtstart="73970" sqlhandle="0x03000c0025118c79381a70019b9e00000100000000000000"/>
</executionStack>
<inputbuf>
Proc [Database Id = 12 Object Id = 2039222565] </inputbuf>
</process>
</blocking-process>
</blocked-process-report>

...全文