Deadlocks CleanCnt

Question

Deadlocks CleanCnt

zach_john

SSCertifiable

Points: 5922
More actions
May 4, 2009 at 1:38 pm

#204268

When looking at deadlock info
SPID: 632 ECID: 0 Statement Type: UPDATE Line #: 63
Owner:0x00000000053A2600 Mode: U Flg:0x0 Ref:1 Life:00000000 SPID:632 ECID:0 XactLockInfo: 0x000000020C4CE358
KEY: 35:72057594870497280 (df009dfcda22) CleanCnt:3 Mode:U Flags: 0x0
What is CleanCnt?
35 is dbid
My object Id is a very high number 72057594870497280 and i cant find it in that db, perhaps a temp table?

John Zacharkan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

zach_john (5/4/2009)
My object Id is a very high number 72057594870497280 and i cant find it in that db, perhaps a temp table?

That's not an objectid. It's a hobt_id (allocation unit id)

To get the object name from one of those, query sys.partitions.

select OBJECT_NAME(object_id) AS TableName

FROM sys.partitions

WHERE hobt_id = 72057594870497280

If it was a temp table, the database id would be 2 (TempDB)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

zach_john SSCertifiable Points: 5922 More actions · Answer 2

Hey Gail,

Forgot about joining up to partitions, thanks for the quick response, didn't i read you live in So Africa? has to be late there.

Any idea what CleanCnt is ?

Thanks for being there no matter what time it is, congrats on your MVP and making geek of the week too!!

Zach

John Zacharkan

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

zach_john (5/4/2009)
Forgot about joining up to partitions, thanks for the quick response, didn't i read you live in So Africa? has to be late there.

Yup, down in SA. Post 10pm, I'm just finishing up

Any idea what CleanCnt is ?

Offhand, no. I can investigate if it's important.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

zach_john SSCertifiable Points: 5922 More actions · Answer 4

Just curious if it were the rows that were being affected by the deadlock and I didn't see anything out there on it. But not critical.

have good night and thanks.

Zach

John Zacharkan