August 20, 2009 at 8:23 am
I was checking the sql server logs and have been seeing a bunch of entries in one of them that look like:
08/20/2009 10:00:59,spid4,Unknown,
08/20/2009 10:00:59,spid4,Unknown,Requested By:
08/20/2009 10:00:59,spid4,Unknown,ResType:LockOwner Stype:'OR' Mode: U SPID:358 ECID:0 Ec:(0x411FF540) Value:0x734e0460 Cost:(0/0)
08/20/2009 10:00:59,spid4,Unknown,Wait-for graph
08/20/2009 10:00:59,spid4,Unknown,
08/20/2009 10:00:59,spid4,Unknown,Node:1
08/20/2009 10:00:59,spid4,Unknown,KEY: 15:942626401:8 (29023d7fa0ad) CleanCnt:2 Mode: U Flags: 0x0
08/20/2009 10:00:59,spid4,Unknown,Grant List 0::
08/20/2009 10:00:59,spid4,Unknown,Owner:0x204705e0 Mode: U Flg:0x0 Ref:1 Life:00000000 SPID:358 ECID:0
08/20/2009 10:00:59,spid4,Unknown,SPID: 358 ECID: 0 Statement Type: UPDATE Line #: 3
08/20/2009 10:00:59,spid4,Unknown,Input Buf: RPC Event: sp_execute;1
08/20/2009 10:00:59,spid4,Unknown,ResType:LockOwner Stype:'OR' Mode: X SPID:291 ECID:0 Ec:(0x6BA15538) Value:0x1ee7b540 Cost:(0/F24)
08/20/2009 10:00:59,spid4,Unknown,
08/20/2009 10:00:59,spid4,Unknown,Node:2
08/20/2009 10:00:59,spid4,Unknown,KEY: 15:942626401:1 (8601d23c5bf0) CleanCnt:2 Mode: X Flags: 0x0
08/20/2009 10:00:59,spid4,Unknown,Grant List 3::
08/20/2009 10:00:59,spid4,Unknown,Owner:0x1ee912e0 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:291 ECID:0
08/20/2009 10:00:59,spid4,Unknown,SPID: 291 ECID: 0 Statement Type: UPDATE Line #: 8
08/20/2009 10:00:59,spid4,Unknown,Input Buf: RPC Event: sp_execute;1
08/20/2009 10:00:59,spid4,Unknown,Requested By:
08/20/2009 10:00:59,spid4,Unknown,Victim Resource Owner:
08/20/2009 10:00:59,spid4,Unknown,ResType:LockOwner Stype:'OR' Mode: U SPID:358 ECID:0 Ec:(0x411FF540) Value:0x734e0460 Cost:(0/0)
08/20/2009 10:00:59,spid4,Unknown,
08/20/2009 10:00:47,spid4,Unknown,
08/20/2009 10:00:47,spid4,Unknown,
08/20/2009 10:00:47,spid4,Unknown,Wait-for graph
Is this just showing that I am having some deadlocking issues?
August 20, 2009 at 8:44 am
Yes, you can get more info by using trace/profiler to grab the data of what is happening with these spids at that time.
August 20, 2009 at 8:55 am
thanks for the quick reply, and those links.
August 20, 2009 at 9:02 am
You are welcome, and please feel free to ask more questions. If you find specific items, be sure to track the code and DDL for the tables if you post again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply