Databases Reference
In-Depth Information
PAGE HEADER:
Page @0x00000002F3994000
m_pageId = (1:73)
m_typeFlagBits = 0x0
m_objId (AllocUnitId.idobj) = 84
Metadata: AllocUnitId = 72057594043432960
Metadata: PartitionId = 72057594039042048
Metadata: ObjectId = 245575913
pminlen = 12
m_freeData = 141
m_xactReserved = 0
m_tornBits = 0
m_headerVersion = 1
m_level = 0
m_indexId (AllocUnitId.idInd) = 256
m_type = 1
m_flagBits = 0x8000
m_prevPage = (0:0)
m_slotCnt = 3
m_reservedCnt = 0
m_xdesId = (0:0)
DB Frag ID = 1
Metadata: IndexId = 0
m_nextPage = (0:0)
m_freeCnt = 8045
m_lsn = (32:78:2)
m_ghostRecCnt = 0
Allocation Status
GAM (1:2) = ALLOCATED
PFS (1:1) = 0X61 MIXED_EXT ALLOCATED
ML (1:7) = NOT MIN_LOGGED
SGAM (1:3) = ALLOCATED
50_PCT_FULL
DIFF (1:6) = CHANGED
DATA:
Slot 0, Offset 0x60, Length 15, DumpStyle BYTE
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP
Record Size = 15
Memory Dump @0x000000001380A060
0000000000000000:
10000c00 01000000 64000000 020000
........d......
Slot 1, Offset 0x6f, Length 15, DumpStyle BYTE
Record Type = PRIMARY_RECORD
Memory Dump @0x000000001380A06F
Record Attributes = NULL_BITMAP
Record Size = 15
0000000000000000:
10000c00 02000000 c8000000 020000
........È......
Slot 2, Offset 0x7e, Length 15, DumpStyle BYTE
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP
Record Size = 15
Memory Dump @0x000000001380A07E
0000000000000000:
10000c00 03000000 2c010000 020000
........,......
OFFSET TABLE:
Row - Offset
2 (0x2) - 126 (0x7e)
1 (0x1) - 111 (0x6f)
0 (0x0) - 96 (0x60)
FIGURE 7-15
HEADER INFORMATION
m_slotCnt=3
m_freedata=141
HEADER
INFORMATION
(1,100)
(2,200)
(3,300)
FIGURE 7-16
Search WWH ::
Custom Search