• This indicates a text mix page which is new to me. The object id is the table. My issue may be more isolation level than the clustering as I previously thought. Thanks for pointing me in a different direction.

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

    PAGE: (1:1662692)

    BUFFER:

    BUF @0x03CC8A0C

    bpage = 0x5CC52000 bhash = 0x00000000 bpageno = (1:1662692)

    bdbid = 5 breferences = 3 bUse1 = 24899

    bstat = 0x4c00009 blog = 0x159a2159 bnext = 0x00000000

    PAGE HEADER:

    Page @0x5CC52000

    m_pageId = (1:1662692) m_headerVersion = 1 m_type = 3

    m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000

    m_objId (AllocUnitId.idObj) = 8934 m_indexId (AllocUnitId.idInd) = 256

    Metadata: AllocUnitId = 72057594623426560

    Metadata: PartitionId = 72057594510245888 Metadata: IndexId = 1

    Metadata: ObjectId = 1806785644 m_prevPage = (0:0) m_nextPage = (0:0)

    pminlen = 0 m_slotCnt = 38 m_freeCnt = 542

    m_freeData = 7840 m_reservedCnt = 0 m_lsn = (87842:11032:62)

    m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0

    m_tornBits = 338776153

    Allocation Status

    GAM (1:1533696) = ALLOCATED SGAM (1:1533697) = NOT ALLOCATED

    PFS (1:1658040) = 0x43 ALLOCATED 95_PCT_FULL DIFF (1:1533702) = NOT CHANGED

    ML (1:1533703) = NOT MIN_LOGGED

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