Deadlock Issue

[johnny76]

Hi,

I am loocking into deadlocks and am logging the events now...I have found an event that I cannot seem to find the corresponding table by the ID given...in one of the occurances:

ResType:LockOwner Stype:'OR' Mode: X SPID:63 ECID:0 Ec:(0x4408B5B8) Value:0x5c5785e0 Cost:(0/0)

Victim Resource Owner:

ResType:LockOwner Stype:'OR' Mode: X SPID:63 ECID:0 Ec:(0x4408B5B8) Value:0x5c5785e0 Cost:(0/0)

Requested By: 

Input Buf: Language Event: exec DB.dbo.TABLE
SPID: 119 ECID: 0 Statement Type: INSERT Line #: 90

Owner:0x60095c60 Mode: S        Flg:0x0 Ref:1 Life:00000000 SPID:119 ECID:0

Grant List 2::

Grant List 0::

KEY: 9:2037582297:1 (ba0332b87dae) CleanCnt:1 Mode: U Flags: 0x0

Node:2

---------------------------

ResType:LockOwner Stype:'OR' Mode: S SPID:119 ECID:0 Ec:(0x4B98D5B8) Value:0x621b2980 Cost:(0/0)

Requested By: 

Input Buf: Language Event: exec DB.dbo.TABLE

SPID: 63 ECID: 0 Statement Type: UPDATE Line #: 397

Owner:0x60075520 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:63 ECID:0

Grant List 0::

KEY: 8:1814453688:7 (a5017c3036d6) CleanCnt:1 Mode: X Flags: 0x0

Node:1

Wait-for graph

I am unable to locate KEY: 9:2037582297:1
DB = 9
Table = 2037582297

Anyone have any idea why I cannot find this table I can find the other. I also do realize that they are in 2 different databases. I am really a developer and new to the stuff. I could use any suggestions...really confused about this?

Any ideas?

CES

 

[SQLDenis]

what do you get back when you run this?

select object_name(2037582297)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[johnny76]

Thanks for the reply!!

When I run that I get the table that I suspected...can you tell me why that id does not come up in the sysobjects table?

CES

Also, do you have any suggestions of where to get more info on understanding this log reading?

 

[johnny76]

Hi,

I also tried running that command on the other id and it returned a different table than when I query the sysobjects table...are you able to clearify what I am doing wrong?

CES

 

[SQLDenis]

are you in the correct database when you run against sysobjects

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[johnny76]

In the QA I can see the table under the DB but when I run:

USE DB
SELECT * FROM [DB].[dbo].[sysobjects]
WHERE
id = 2037582297


I get no records. Is it possible that there is a big problem here? Maybe corrupt table?

CES

 

[johnny76]

Sorry but I have another small question...When the deadlock is logged is this always a big deal?

CES