Post reply

Explain waitresource in master..sysprocesses

  • September 12, 2005 at 6:23 am

    #91178

    Hello,

    During investigation of a locking issue I found the following in the 'waitresource' column of master..sysprocesses:

    RID: 6:1:92:0

    I know that 'RID' means some sort of a row lock but what are all other numbers? Can this information be used to find the locked object/row?

    Thanks for your help,

    Christophe

     

  • September 12, 2005 at 8:08 am

    #589093

    RID is in the format of  db_id:file_id:page_no:row_no.

    You can use DBCC PAGE to find out the object in the page.

    DBCC PAGE (6,1,92,0)

    For the deatil output of DBCC PAGE, you search it in google.

  • September 12, 2005 at 8:10 am

    #589094

    Row DatabaseID:FileIDageID:Slot(row) RID: 5:1:104:3

    In this case, database ID 5 is pubs, file ID 1 is the primary data file, page 104 is a page belonging to the titles table, and slot 3 indicates the row's position on the page.

    You can find this explanation, and more here.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;224453

    /Kenneth

  • September 12, 2005 at 8:13 am

    #589095

    Forgot to say you need to run DBCC TRACEON(3604)  first to direct the output of DBCC PAGE to QA. So the command should be:

    DBCC TRACEON(3604)

    GO

    DBCC PAGE (....)

    GO

     

  • September 21, 2005 at 9:48 am

    #591851

    Hi, does anyone know what APP: XS_M7bca83f3) in the Waitresource would mean?

     

  • September 23, 2005 at 1:48 am

    #592502

    Nope, got no clue.

    Is it giving you a problem, or just curious? Perhaps you better as the question in a new thread, it will be easier for others to pick it up then.

    /Kenneth

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

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