Post reply

Finding the table given a page resource ID

  • August 1, 2003 at 2:43 pm

    #80928

    I'm trying to debug a deadlock situation, and one of the resources involved is a page, that appears in the format "PAG: 7:1:181549". Is there a way to figure out to which table/index this page belongs, given the ID of the page resource? Thanks.

  • August 4, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • August 5, 2003 at 2:59 am

    #468594

    select object_name(your_resource_id)

    best regards,

    chris.

  • August 6, 2003 at 8:03 am

    #468833

    From MSDN

    PAG: db_id:file_id:page_no;

    So you know your database and file segment in database. So now you know at least list of tables which are in the file segment by looking at table schema. Then you can research on sysindexes table which provide you first page, last page, and count of pages allocated. I think the page_no you get in lock info is relative to the file group.

    Next thing you can try is review Process info in Enterprise manager. 90% of times it list the table (even system generated temp table) in Lock/objects.

  • August 6, 2003 at 8:17 am

    #468841

    You can also use.

    DBCC TRACEON (1204)

    or

    SQL Profiler

    Follow BOL "Troubleshooting Deadlocks"

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

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