Deadlock in Error log - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Deadlock in Error log

Author

Topic

chulheekim
Starting Member

46 Posts

Posted - 2010-11-05 : 21:34:15

From the error log below, I could get information about who was killed and on what table. However, what about the other guy. All I could see is RPC sp_executesql. I'm pretty sure it is either from web server or another sql server. Is there any way to get further information? How about turning on the Profiler all day hoping that the deadlock happen again, and finding out what the spid was doing? Do you have any better way?

Deadlock encountered .... Printing deadlock information
2010-11-05 11:30:48.77 spid2 Wait-for graph
2010-11-05 11:30:48.77 spid2 Node:1
2010-11-05 11:30:48.77 spid2 RID: 6:1:4570:1 CleanCnt:2 Mode: X Flags: 0x2
2010-11-05 11:30:48.77 spid2 Grant List 3::
2010-11-05 11:30:48.77 spid2 Owner:0x42c223e0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:77 ECID:0
2010-11-05 11:30:48.77 spid2 SPID: 77 ECID: 0 Statement Type: CONDITIONAL Line #: 35
2010-11-05 11:30:48.77 spid2 Input Buf: RPC Event: sp_executesql;1
2010-11-05 11:30:48.77 spid2 Requested By:
2010-11-05 11:30:48.77 spid2 ResType:LockOwner Stype:'OR' Mode: U SPID:67 ECID:0 Ec0x229395F0) Value:0x42beff00 Cost0/35A8)
2010-11-05 11:30:48.77 spid2
2010-11-05 11:30:48.77 spid2 Node:2
2010-11-05 11:30:48.77 spid2 KEY: 6:5575058:1 (49022c876b48) CleanCnt:2 Mode: X Flags: 0x0
2010-11-05 11:30:48.77 spid2 Grant List 1::
2010-11-05 11:30:48.77 spid2 Owner:0x42bef1e0 Mode: X Flg:0x0 Ref:1 Life:02000000 SPID:67 ECID:0
2010-11-05 11:30:48.77 spid2 SPID: 67 ECID: 0 Statement Type: UPDATE Line #: 29
2010-11-05 11:30:48.77 spid2 Input Buf: Language Event: exec u_Rx_CreateStagesEvery5min
2010-11-05 11:30:48.77 spid2 Requested By:
2010-11-05 11:30:48.77 spid2 ResType:LockOwner Stype:'OR' Mode: S SPID:77 ECID:0 Ec0x63731560) Value:0x6b858180 Cost0/38E0)
2010-11-05 11:30:48.77 spid2 Victim Resource Owner:
2010-11-05 11:30:48.77 spid2 ResType:LockOwner Stype:'OR' Mode: U SPID:67 ECID:0 Ec0x229395F0) Value:0x42beff00 Cost0/35A8)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources