数据库死锁

最新推荐文章于 2025-05-25 10:54:50 发布

iteye_13312

最新推荐文章于 2025-05-25 10:54:50 发布

阅读量119

点赞数

CC 4.0 BY-SA版权

分类专栏：杂谈文章标签： SQL

本文链接：https://blog.youkuaiyun.com/iteye_13312/article/details/82068054

杂谈专栏收录该内容

5 篇文章

订阅专栏

0      317     lock sleep NMSuser      NMSuser      (null)            218     MCDB              tempdb         SELECT                       0
   0      218     lock sleep NMSuser      NMSuser      (null)            317     MCDB              tempdb         INSERT                       0

   W (1): SQL Text: DB..t2ksp_G
   W (2): Executing procedure: t2ksp_GetEvents
   W (3): Subordinate SQL Text: select tbl_EventBuffer.TunnelID, tbl_EventBuffer.Serial, SerialContext, tbl_EventBuffer.EventID,
   W (4):         tbl_EventBuffer.SenderProcID, tbl_EventBuffer.SenderProcHandle,
   W (5):         tbl_ReceivedEvent.TryCount, tbl_EventBuffer.EventState
   W (6):         from tbl_EventBuffer, tbl_ReceivedEvent
   W (7):         where tbl_EventBuffer.Serial = tbl_ReceivedEvent.Serial
   W (8):             and tbl_ReceivedEvent.RecvProcID = @procID
   W (9):             and (tbl_ReceivedEvent.RecvProcHandle = @procHandle or tbl_ReceivedEvent.RecvProcHandle = 0)
   W (10):             and tbl_ReceivedEvent.RecvTaskMgrID = @taskMgrID and tbl_ReceivedEvent.Serial > @serialID
   W (11):         order by tbl_EventBuffer.Serial

   W (1): SQL Text: DB..t2ksp_WriteE
   W (2): Executing procedure: Trg_InsertEventBuffer
   W (3): Subordinate SQL Text: insert into tbl_ReceivedEvent(Serial,RecvProcID,RecvProcHandle,RecvTaskMgrID)
   W (4):        select @Serial, RecvProcID, RecvProcHandle, RecvTaskMgrID from tbl_SubscribEvent,inserted
   W (5):        where tbl_SubscribEvent.EventID = inserted.EventID and (tbl_SubscribEvent.EventState & 0x00000010 = 0)