Deadlock : What the meaning of associatedObjectId

In 2005, when 1222 trace flag is activated, I get in the error log file, amo
ng other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=....
id=lock5f69480 mode=IX associatedObjectId=7205759437851852
8
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant informatio
n
Thanks
MedHi
This should match a waitresource in the process list and in the waiter list,
you should also should also see that database id for this which is probably
2
ie tempdb.
Check out Bart Duncan Blog
http://blogs.msdn.com/bartd/archive...
-1.aspx
John
"Med Bouchenafa" wrote:

> In 2005, when 1222 trace flag is activated, I get in the error log file, a
mong other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX objectname=...
. id=lock5f69480 mode=IX associatedObjectId=72057594378518
528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related
to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant informat
ion
> Thanks
> Med
>|||Med,
I don't know if the associatedObjectId will help you any, although you do
have the dbid and the objectname to focus your attention. From the Books
Online article "Detecting and Ending Deadlocks"
http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
associatedObjectId. Represents the HoBT (heap or b-tree) ID.
RLF
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
In 2005, when 1222 trace flag is activated, I get in the error log file,
among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=....
id=lock5f69480 mode=IX associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
information
Thanks
Med|||You're right...
That's the way it is documented in the books online.
To have the object name, I run a query like this
SELECT OBJECT_NAME(object_id) FROM sys.partitions WHERE partition_id =
@.associatedObjectId
and it worked
What surprised me is the fact that they all started with 72057594xxxxx
It looks like partion_id is a component of two or more values...
Thanks again
Med
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uSgP$qVTIHA.5404@.TK2MSFTNGP03.phx.gbl...
> Med,
> I don't know if the associatedObjectId will help you any, although you do
> have the dbid and the objectname to focus your attention. From the Books
> Online article "Detecting and Ending Deadlocks"
> http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
> associatedObjectId. Represents the HoBT (heap or b-tree) ID.
> RLF
> "Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
> news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
> In 2005, when 1222 trace flag is activated, I get in the error log file,
> among other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
> id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX
> objectname=.... id=lock5f69480 mode=IX
> associatedObjectId=72057594378518528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related
> to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
> information
> Thanks
> Med
>
>