数据库经常发生阻塞日志的内容是什么意思？（求助）

[skeeterLa]

<blocked-process-report monitorLoop="940196">
<blocked-process>
<process id="processfb0f28" taskpriority="0" logused="0" waitresource="OBJECT: 7:1440268436:0 " waittime="9578" ownerId="713776000" transactionname="UPDATE" lasttranstarted="2012-05-07T08:14:31.803" XDES="0x7ad2a250" lockMode="IX" schedulerid="6" kpid="2032" status="suspended" spid="74" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2012-05-07T08:14:31.803" lastbatchcompleted="2012-05-07T08:14:31.803" clientapp=".Net SqlClient Data Provider" hostname="WEBAPP" hostpid="2572" loginname="SSASUserLianQi" isolationlevel="read committed (2)" xactid="713776000" currentdb="7" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame line="75" stmtstart="5834" stmtend="6186" sqlhandle="0x03000700743a9a4cf6fa6c0137a000000100000000000000"/>
<frame line="1" stmtstart="308" sqlhandle="0x010007008d0f7336b8918d37000000000000000000000000"/>
<frame line="1" sqlhandle="0x000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@p0 int output,@p1 int,@p2 nvarchar(4),@p3 nvarchar(3),@p4 nvarchar(4000),@p5 int,@p6 datetime,@p7 int,@p8 nvarchar(100) output,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[PROC_YWSJ_UPdate_DINGDAN] @BG_ID = @p0 OUTPUT, @DH_INDEX = @p1, @BeiZhu = @p2, @LuRuRen = @p3, @TSQL = @p4, @PeiSongYuanID = @p5, @YueDingRiQi = @p6, @MD_ID = @p7, @TAG = @p8 OUTPUT </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="suspended" waitresource="OBJECT: 7:1440268436:0 " waittime="10718" spid="58" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2012-05-07T08:14:30.660" lastbatchcompleted="2012-05-07T08:14:30.660" clientapp=".Net SqlClient Data Provider" hostname="WEBAPP" hostpid="2572" loginname="SSASUserLianQi" isolationlevel="serializable (4)" xactid="713775731" currentdb="7" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="75" stmtstart="3802" stmtend="5186" sqlhandle="0x030007001235510f656cec00ad9f00000100000000000000"/>
<frame line="1" stmtstart="778" sqlhandle="0x01000700f956ea1e50a1c65c000000000000000000000000"/>
<frame line="1" sqlhandle="0x000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@p0 uniqueidentifier,@p1 int,@p2 int,@p3 datetime,@p4 nvarchar(2),@p5 int,@p6 int output,@p7 nvarchar(4000),@p8 decimal(20,4),@p9 int,@p10 nvarchar(11),@p11 nvarchar(3),@p12 int,@p13 smallint,@p14 int,@p15 varchar(8000),@p16 int,@p17 nvarchar(4000),@p18 nvarchar(4),@p19 nvarchar(4000),@p20 bit output,@p21 int,@p22 nvarchar(16),@p23 int,@p24 nvarchar(30) output,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[PROC_YW_SAVEup_DINGDAN] @DINGDAN_ID = @p0, @MD_ID = @p1, @KH_ID = @p2, @YueDingShiJian = @p3, @PeiSongYaoQiu = @p4, @YeWuYuanID = @p5, @PeiSongYuanID = @p6 OUTPUT, @XiaoShouFangShi = @p7, @YingShouHeJi = @p8, @YingShouPiao = @p9, @BeiZhu = @p10, @LuRuRen = @p11, @LuRuRen_ID = @p12, @ZhuangTai = @p13, @LuRuMenDian_ID = @p14, @DanJuZiBianHao = @p15, @KeHu_DiZhi_ID = @p16, @CanYuXiaoShouFangAnID = @p17, @DanJuSuXing = @p18, @DH_ZhaiYao = @p19, @DH_YDSW = @p20 OUTPUT, @OLDDINGDAN_ID = @p21, @DanHao = @p22, @DH_INDEX = @p23, @TAG = @p24 OUTPUT </inputbuf>
</process>
</blocking-process>
</blocked-process-report>

[skeeterLa]

<blocked-process-report monitorLoop="940196">
<blocked-process>
<process id="processfc6d48" taskpriority="0" logused="0" waitresource="OBJECT: 7:1440268436:0 " waittime="11875" ownerId="713775098" transactionname="SELECT" lasttranstarted="2012-05-07T08:14:29.507" XDES="0x43ab8e0" lockMode="S" schedulerid="7" kpid="5172" status="suspended" spid="56" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2012-05-07T08:14:29.507" lastbatchcompleted="2012-05-07T08:14:29.507" clientapp=".Net SqlClient Data Provider" hostname="WEBAPP" hostpid="2572" loginname="SSASUserLianQi" isolationlevel="serializable (4)" xactid="713775098" currentdb="7" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame line="4" stmtstart="74" sqlhandle="0x02000000beb40200efbdf42efc099c64db875a5157186050"/>
<frame line="1" sqlhandle="0x0400ff7fbe80662601000000000000000000000000000000"/>
<frame line="33" stmtstart="1948" sqlhandle="0x03000700e4d9a278ada11200e29e00000100000000000000"/>
</executionStack>
<inputbuf>
Proc [Database Id = 7 Object Id = 2023938532] </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="suspended" waitresource="7:1:1793016" waittime="31" spid="79" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2012-05-07T08:14:27.507" lastbatchcompleted="2012-05-07T08:14:27.507" clientapp=".Net SqlClient Data Provider" hostname="WEBAPP" hostpid="2572" loginname="SSASUserLianQi" isolationlevel="serializable (4)" xactid="713774684" currentdb="7" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame line="75" stmtstart="4828" stmtend="4972" sqlhandle="0x030007004be7fc27702f1200e29e00000100000000000000"/>
<frame line="1" stmtstart="358" sqlhandle="0x01000700afb17901a87fa22a000000000000000000000000"/>
<frame line="1" sqlhandle="0x000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@p0 uniqueidentifier,@p1 int,@p2 uniqueidentifier,@p3 int,@p4 nvarchar(4000),@p5 nvarchar(3),@p6 uniqueidentifier output,@p7 int,@p8 nvarchar(30) output,@RETURN_VALUE int output)EXEC @RETURN_VALUE = [dbo].[PROC_CW_SAVEup_CongDan] @HUIDAN_ID = @p0, @MD_ID = @p1, @DINGDAN_ID = @p2, @KH_ID = @p3, @CD_YuanYin = @p4, @CD_LuRuRen = @p5, @CD_ID = @p6 OUTPUT, @HD_DanJuLeiXingID = @p7, @TAG = @p8 OUTPUT </inputbuf>
</process>
</blocking-process>
</blocked-process-report>

[唐诗三百首]

阻塞一般是由锁争等待造成的,

可以用系统存储过程 sp_lock 查看.

[夜予]

也可能是同时多进程并发造成的
第一个是update操作等待，第二个是select操作等待

[让你望见影子的墙]

日志中应该是各个进程的信息，其实你可以通过profile看看到底是那些语句引起的阻塞。
然后针对这些语句进行优化