• Yes, you are correct the third one is the page number.

    Say you have a wait on resource 5:1:9337310

    In my case DB 5 is Items and File 1 is Items_Data.

    Run the following to get the object info:

    dbcc traceon (3604)

    go

    dbcc page (5, 1, 9337310)

    The output shows the objectId : m_objId = 978102525

    Then object_name (id) gives you the object.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    PAGE: (1:9337310)

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

    BUFFER:

    -------

    BUF @0x19A3E680

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

    bpage = 0x7B764000 bhash = 0x00000000 bpageno = (1:9337310)

    bdbid = 5 breferences = 1 bstat = 0x9

    bspin = 0 bnext = 0x00000000

    PAGE HEADER:

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

    Page @0x7B764000

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

    m_pageId = (1:9337310) m_headerVersion = 1 m_type = 1

    m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000

    m_objId = 978102525 m_indexId = 0 m_prevPage = (1:9337311)

    m_nextPage = (1:9337309) pminlen = 68 m_slotCnt = 109

    m_freeCnt = 30 m_freeData = 7944 m_reservedCnt = 0

    m_lsn = (9238:816300:27) m_xactReserved = 0 m_xdesId = (0:0)

    m_ghostRecCnt = 0 m_tornBits = 37750929

    Allocation Status

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

    GAM (1:9202176) = ALLOCATED

    SGAM (1:9202177) = NOT ALLOCATED

    PFS (1:9333552) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:9202182) = CHANGED

    ML (1:9202183) = NOT MIN_LOGGED