August 23, 2010 at 7:02 am
Hi
How to know what object or index is on particular Page
I ran following command
DBCC Page(51,6,5008984,3) WITH TABLERESULTS
& this is the output
BUFFER:BUF @0x00000001EDFEB580bpage0x00000001EDAD6000
BUFFER:BUF @0x00000001EDFEB580bhash0x0000000000000000
BUFFER:BUF @0x00000001EDFEB580bpageno(6:5008984)
BUFFER:BUF @0x00000001EDFEB580bdbid51
BUFFER:BUF @0x00000001EDFEB580breferences0
BUFFER:BUF @0x00000001EDFEB580bUse19409
BUFFER:BUF @0x00000001EDFEB580bstat0xdc00009
BUFFER:BUF @0x00000001EDFEB580blog0x21212159
BUFFER:BUF @0x00000001EDFEB580bnext0x0000000000000000
PAGE HEADER:Page @0x00000001EDAD6000m_pageId(6:5008984)
PAGE HEADER:Page @0x00000001EDAD6000m_headerVersion1
PAGE HEADER:Page @0x00000001EDAD6000m_type1
PAGE HEADER:Page @0x00000001EDAD6000m_typeFlagBits0x0
PAGE HEADER:Page @0x00000001EDAD6000m_level0
PAGE HEADER:Page @0x00000001EDAD6000m_flagBits0x200
PAGE HEADER:Page @0x00000001EDAD6000m_objId (AllocUnitId.idObj)17836
PAGE HEADER:Page @0x00000001EDAD6000m_indexId (AllocUnitId.idInd)256
PAGE HEADER:Page @0x00000001EDAD6000Metadata: AllocUnitId72057595206828032
PAGE HEADER:Page @0x00000001EDAD6000Metadata: PartitionId0
PAGE HEADER:Page @0x00000001EDAD6000Metadata: IndexId-1
PAGE HEADER:Page @0x00000001EDAD6000Metadata: ObjectId0
PAGE HEADER:Page @0x00000001EDAD6000m_prevPage(6:5008983)
PAGE HEADER:Page @0x00000001EDAD6000m_nextPage(6:5008985)
PAGE HEADER:Page @0x00000001EDAD6000pminlen56
PAGE HEADER:Page @0x00000001EDAD6000m_slotCnt36
PAGE HEADER:Page @0x00000001EDAD6000m_freeCnt1408
PAGE HEADER:Page @0x00000001EDAD6000m_freeData6712
PAGE HEADER:Page @0x00000001EDAD6000m_reservedCnt0
PAGE HEADER:Page @0x00000001EDAD6000m_lsn(122130:13313:4)
PAGE HEADER:Page @0x00000001EDAD6000m_xactReserved0
PAGE HEADER:Page @0x00000001EDAD6000m_xdesId(0:0)
PAGE HEADER:Page @0x00000001EDAD6000m_ghostRecCnt0
PAGE HEADER:Page @0x00000001EDAD6000m_tornBits1392242637
PAGE HEADER:Allocation StatusGAM (6:4601088)NOT ALLOCATED
PAGE HEADER:Allocation StatusSGAM (6:4601089)NOT ALLOCATED
PAGE HEADER:Allocation StatusPFS (6:5006472)0x0 0_PCT_FULL
PAGE HEADER:Allocation StatusDIFF (6:4601094)NOT CHANGED
PAGE HEADER:Allocation StatusML (6:4601095)NOT MIN_LOGGED
but I am not able to get what is object on this page
regards
ghanshyam
August 23, 2010 at 9:25 am
PAGE HEADER: Page @0x00000001EDAD6000 m_objId (AllocUnitId.idObj) 17836
17836 is the object ID and select object_name(17836) would give you the object name
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 23, 2010 at 9:34 am
The key lines are these
PAGE HEADER:Page @0x00000001EDAD6000Metadata: PartitionId0
PAGE HEADER:Page @0x00000001EDAD6000Metadata: IndexId-1
PAGE HEADER:Page @0x00000001EDAD6000Metadata: ObjectId0
Object 0, index -1 means this is not allocated.
In addition
PAGE HEADER: Allocation Status GAM (6:4601088) NOT ALLOCATED
PAGE HEADER: Allocation Status SGAM (6:4601089) NOT ALLOCATED
The page is not allocated in either of the two main allocation maps. Hence you're looking at an unallocated page.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply