查看页面的数据

最新推荐文章于 2022-12-11 19:35:45 发布

ivandick

最新推荐文章于 2022-12-11 19:35:45 发布

阅读量555

点赞数

分类专栏： SQL Server 文章标签： attributes allocation 数据库 null blog header

本文链接：https://blog.csdn.net/ivandick/article/details/5867275

版权

SQL Server 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

DBCC PAGE({dbid|dbname},filename,pagenum[,printopt]) WITH TABLERESULTS

dbid-- 数据库的ID

dbname -- 数据库的名称

filename -- 数据文件号

pagenum -- 数据文件内的数据页面号（从0开始编号）

printopt -- 0：显示缓存池中该页面的头部、数据页面头部（默认选项）；

1：显示缓存池中该页面的头部、数据页面头部、每个独立的数据行、行偏移数组；

2：显示缓存池中该页面的头部、数据页面头部、整个页面、行偏移数组；

3：显示缓存池中该页面的头部、数据页面头部、每个独立的数据行、行偏移数组，每个数据行后面分别列出各列的值。

Example：

DBCC TRACEON (3604)；--打开跟踪标记 DBCC PAGE (DatabaseName, 1, 0, 3) SELECT NAME,DBID FROM Master.. SYSDATABASES -- 数据库ID和名称 SELECT FILEID,SIZE,FILENAME FROM Northwind..SYSFILES --数据文件ID和名称 ================================================================================= /*一个查询的数据页面信息文件号1、数据页110*/ PAGE: (1:110) BUFFER: /*内存中的叶号*/ BUF @0x03AB431C bpage = 0x0605A000 bhash = 0x00000000 bpageno = (1:110) bdbid = 5 breferences = 0 bUse1 = 3843 bstat = 0xc00009 blog = 0x32159 bnext = 0x00000000 /*物理页头部信息*/ PAGE HEADER: /*物理页所在的叶号*/ Page @0x0605A000 m_pageId = (1:110) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8200 m_objId (AllocUnitId.idObj) = 41 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594040614912 Metadata: PartitionId = 72057594039566336 Metadata: IndexId = 0 Metadata: ObjectId = 149575571 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 8 m_slotCnt = 4 m_freeCnt = 7970 m_freeData = 214 m_reservedCnt = 0 m_lsn = (26:262:3) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = -372857325 /*物理页头部中的整个文件的管理页面的页面分配信息*/ 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 /*物理数据区Slot 0的数据，偏移量0x60*/ Slot 0 Offset 0x60 Length 25 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Record Size = 25 Memory Dump @0x3E5EC060 00000000: 30000800 01000000 02000001 00190064 †0..............d 00000010: 00750077 00650069 00†††††††††††††††††.u.w.e.i. Slot 0 Column 1 Offset 0x4 Length 4 Length (physical) 4 TeacherID = 1 Slot 0 Column 2 Offset 0xf Length 10 Length (physical) 10 TeacherName = duwei /*物理数据区Slot 1的数据，偏移量0x79*/ Slot 1 Offset 0x79 Length 33 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Record Size = 33 Memory Dump @0x3E5EC079 00000000: 30000800 02000000 02000001 0021007a †0............!.z 00000010: 00680061 006e0067 006c0069 006c0069 †.h.a.n.g.l.i.l.i 00000020: 00†††††††††††††††††††††††††††††††††††. Slot 1 Column 1 Offset 0x4 Length 4 Length (physical) 4 TeacherID = 2 Slot 1 Column 2 Offset 0xf Length 18 Length (physical) 18 TeacherName = zhanglili /*物理数据区Slot 2的数据，偏移量0x9a*/ Slot 2 Offset 0x9a Length 25 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Record Size = 25 Memory Dump @0x3E5EC09A 00000000: 30000800 03000000 02000001 00190068 †0..............h 00000010: 00650079 0075006e 00†††††††††††††††††.e.y.u.n. Slot 2 Column 1 Offset 0x4 Length 4 Length (physical) 4 TeacherID = 3 Slot 2 Column 2 Offset 0xf Length 10 Length (physical) 10 TeacherName = heyun /*物理数据区Slot 3的数据，偏移量0xb3 */ Slot 3 Offset 0xb3 Length 35 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Record Size = 35 Memory Dump @0x3E5EC0B3 00000000: 30000800 04000000 02000001 0023006c †0............#.l 00000010: 00690075 00680075 00690070 0069006e †.i.u.h.u.i.p.i.n 00000020: 006700†††††††††††††††††††††††††††††††.g. Slot 3 Column 1 Offset 0x4 Length 4 Length (physical) 4 TeacherID = 4 Slot 3 Column 2 Offset 0xf Length 20 Length (physical) 20 TeacherName = liuhuiping DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 ============================================================================= 内存是如何管理数据页面的 /*内存中的叶号*/ BUF @0x03AB431C bpage = 0x0605A000 bhash = 0x00000000 bpageno = (1:110) bdbid = 5 breferences = 0 bUse1 = 3843 bstat = 0xc00009 blog = 0x32159 bnext = 0x00000000 bpage 唯一的物理页面号 bhash 页面的内存中保存hash函数值，用于快速查找内存页面 bpageno 物理页面的文件号、页面编号 bdbid 数据库的ID ============================================================================= 物理页面是如何管理数据页面的 /*物理页所在的叶号*/ Page @0x0605A000 m_pageId = (1:110) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8200 m_objId (AllocUnitId.idObj) = 41 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594040614912 Metadata: PartitionId = 72057594039566336 Metadata: IndexId = 0 Metadata: ObjectId = 149575571 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 8 m_slotCnt = 4 m_freeCnt = 7970 m_freeData = 214 m_reservedCnt = 0 m_lsn = (26:262:3) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = -372857325 /*物理页头部中的整个文件的管理页面的页面分配信息*/ 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