DBCC PAGE 中数据页的 HEADER 理解

use dbpage
go;
create table tbl_flowers(
  id int identity(1,1) not null,
  flowername char(5)
  );
--插入两行数据
insert into tbl_flowers(flowername)values('rose');
insert into tbl_flowers(flowername)values('rose');

dbcc traceon(3604)
dbcc ind(dbpage,tbl_flowers,-1)
dbcc page(dbpage,1,174,2)
--下面的页信息用不同的底色进行了标识

Page @0x0C4DC000

m_pageId = (1:174)

m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8200

m_objId (AllocUnitId.idObj) = 34 m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594040156160
Metadata: PartitionId = 72057594039042048 Metadata: IndexId = 0
Metadata: ObjectId = 53575229

m_prevPage = (0:0) m_nextPage = (0:0)
pminlen = 13 m_slotCnt = 2

m_freeCnt = 8060 m_freeData = 128

m_reservedCnt = 0

m_lsn = (14745:386:3) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0

m_tornBits = -475782764

Allocation Status

GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED
PFS (1:1) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED

DATA:

Memory Dump @0x644AC000

644AC000: 01010400 00820001 00000000 00000d00 †................
644AC010: 00000000 00000200 22000000 7c1f8000 †........"...|...
644AC020: ae000000 01000000 99390000 82010000 †.........9......
644AC030: 03000000 00000000 00000000 9421a4e3 †.............!..
644AC040: 00000000 00000000 00000000 00000000 †................
644AC050: 00000000 00000000 00000000 00000000 †................