SQL Server 2005 用DBCC LOG命令调出日志信息,信息中PAGEID是几进制的? Page ID:0001:00000121,换算成十进制是多少?sql server 2005 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 而前面的0001应该文件id,也就是fileID是1 dbcc page (test,1,119,3)中的1是不是就是filedID,3又是什么意思 dbcc page (test,1,119,3)中的1是不是就是filedID,3又是什么意思对的,1是fileID,3是一种输出格式,输出详细信息。 dbcc page (test,1,119,3)中的1是不是就是filedID,3又是什么意思你要看详细信息就用3,一般可以显示出能读的数据,如果2的话,好像是没有经过解释的 PAGE: (1:119)BUFFER:BUF @0x0000000082FC4C80bpage = 0x0000000082132000 bhash = 0x0000000000000000 bpageno = (1:119)bdbid = 5 breferences = 3 bUse1 = 10571bstat = 0xc00009 blog = 0x21212159 bnext = 0x0000000000000000PAGE HEADER:Page @0x0000000082132000m_pageId = (1:119) m_headerVersion = 1 m_type = 1m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8200m_objId (AllocUnitId.idObj) = 117 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594045595648 Metadata: PartitionId = 72057594040156160 Metadata: IndexId = 0Metadata: ObjectId = 565577053 m_prevPage = (0:0) m_nextPage = (0:0)pminlen = 8 m_slotCnt = 6 m_freeCnt = 8018m_freeData = 162 m_reservedCnt = 0 m_lsn = (24:466:2)m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0m_tornBits = -1100709213 Allocation StatusGAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:1) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGEDML (1:7) = NOT MIN_LOGGED Slot 0 Offset 0x60 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000B93C0600000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 0 Column 0 Offset 0x4 Length 4a = 2 Slot 1 Offset 0x6b Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000B93C06B0000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 1 Column 0 Offset 0x4 Length 4a = 2 Slot 2 Offset 0x76 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000B93C0760000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 2 Column 0 Offset 0x4 Length 4a = 2 Slot 3 Offset 0x81 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000B93C0810000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 3 Column 0 Offset 0x4 Length 4a = 2 Slot 4 Offset 0x8c Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000B93C08C0000000000000000: 10000800 01000000 0100fe†††††††††††††........... Slot 4 Column 0 Offset 0x4 Length 4a = 1 Slot 5 Offset 0x97 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000B93C0970000000000000000: 10000800 01000000 0100fe†††††††††††††........... Slot 5 Column 0 Offset 0x4 Length 4a = 1 这些能不能给简单解释一下呢? 1、buffer部分:bpageno 就是页号,dbid就是数据库id2、PAGE HEADER:m_prevPage = (0:0) 如果页面处于页链中,表示上一个页面 m_nextPage = (0:0) 表示下一个页面m_slotCnt = 6 表示已分配的记录数,就是有6条记录3、Allocation StatusGAM (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 用于最小化日志,大容量日志4、Slot 0 Column 0 Offset 0x4 Length 4就是第0行记录,第0列 呵呵,要解析这些,我建议你参考一下这个本书吧,挺详细的:Microsoft SQL Server 2005技术内幕:存储引擎你搜搜网上应该有电子版的哈 如何设计数据库? 为何在object_id()函数中,不认数据库名呢?下面写就不行,假如数据库名为:db [code=SQL] select * from dataserver. 关于sa登录密码的问题 问一个非常奇怪的问题,关于一条极简单的查询语句 如何按行取最大、中间、最小值! SQL能不能将一行数据分几行显示 新人一个查询的问题 这个问题究竟怎么解决啊? 关于cbuilder中属性的问题!散分!来者有分,你们辛苦了! 调试PROCEDURE如何查看内部设置变量数值的变化 求一个sql排序语句 server=.与server=.\sql2008有区别的吗????????????
PAGE: (1:119)
BUFFER:
BUF @0x0000000082FC4C80bpage = 0x0000000082132000 bhash = 0x0000000000000000 bpageno = (1:119)
bdbid = 5 breferences = 3 bUse1 = 10571
bstat = 0xc00009 blog = 0x21212159 bnext = 0x0000000000000000PAGE HEADER:
Page @0x0000000082132000m_pageId = (1:119) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8200
m_objId (AllocUnitId.idObj) = 117 m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594045595648
Metadata: PartitionId = 72057594040156160 Metadata: IndexId = 0
Metadata: ObjectId = 565577053 m_prevPage = (0:0) m_nextPage = (0:0)
pminlen = 8 m_slotCnt = 6 m_freeCnt = 8018
m_freeData = 162 m_reservedCnt = 0 m_lsn = (24:466:2)
m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
m_tornBits = -1100709213 Allocation StatusGAM (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 Offset 0x60 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x000000000B93C0600000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 0 Column 0 Offset 0x4 Length 4a = 2 Slot 1 Offset 0x6b Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x000000000B93C06B0000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 1 Column 0 Offset 0x4 Length 4a = 2 Slot 2 Offset 0x76 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x000000000B93C0760000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 2 Column 0 Offset 0x4 Length 4a = 2 Slot 3 Offset 0x81 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x000000000B93C0810000000000000000: 10000800 02000000 0100fe†††††††††††††........... Slot 3 Column 0 Offset 0x4 Length 4a = 2 Slot 4 Offset 0x8c Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x000000000B93C08C0000000000000000: 10000800 01000000 0100fe†††††††††††††........... Slot 4 Column 0 Offset 0x4 Length 4a = 1 Slot 5 Offset 0x97 Length 11Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP
Memory Dump @0x000000000B93C0970000000000000000: 10000800 01000000 0100fe†††††††††††††........... Slot 5 Column 0 Offset 0x4 Length 4a = 1
这些能不能给简单解释一下呢?
m_prevPage = (0:0) 如果页面处于页链中,表示上一个页面
m_nextPage = (0:0) 表示下一个页面
m_slotCnt = 6 表示已分配的记录数,就是有6条记录3、Allocation StatusGAM (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 用于最小化日志,大容量日志4、
Slot 0 Column 0 Offset 0x4 Length 4
就是第0行记录,第0列