主页 / dba / 问题 / 184455
Accepted
Jonesome Reinstate Monica
Asked: 2017-08-28 15:41:48 +0800 CST

8KB 行限制是“硬限制”吗？

  • 772

根据SQL Server 文档，看起来如果我有一个或多个 varchar/nvarchar 列导致行长度超过 8KB，SQL Server 会神奇地处理它。

场景：
- 表有 100
列 - 当前最大行长度为 3.4KB
- 但是如果每个 varchar/nvarchar 字段都填充到最大值，行长度将达到 14kb

从我对上面链接的联机丛书详细信息的解释来看，这种情况会很顺利（例如，什么都不会中断，一切都会正常进行）。

我的假设是真的吗？

sql-server sql-server-2016

1 个回答

  1. Best Answer

    使用未记录的功能DBCC IND和DBCC PAGE，您可以很容易地准确知道 SQL Server 对超过 8,060 字节“最大”大小的行做了什么。

    为了展示这是如何工作的，我将在 tempdb 中创建一个简单的表，其中行宽为 10,000 字节，然后运行DBCC IND以获取存储数据的页面列表。然后我们将运行DBCC PAGE以查看这些页面的内容。

    首先，我们创建最大宽度为 10,000 字节的表：

    SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.WidthTest', N'U') IS NOT NULL
DROP TABLE dbo.WidthTest;
CREATE TABLE dbo.WidthTest
(
      Col01 varchar(1000) NOT NULL
    , Col02 varchar(1000) NOT NULL
    , Col03 varchar(1000) NOT NULL
    , Col04 varchar(1000) NOT NULL
    , Col05 varchar(1000) NOT NULL
    , Col06 varchar(1000) NOT NULL
    , Col07 varchar(1000) NOT NULL
    , Col08 varchar(1000) NOT NULL
    , Col09 varchar(1000) NOT NULL
    , Col10 varchar(1000) NOT NULL
) ON [PRIMARY];

    并用一行填充它：

    INSERT INTO dbo.WidthTest (Col01, Col02, Col03, Col04, Col05, Col06, Col07, Col08, Col09, Col10)
VALUES (
      REPLICATE('A', 1000)
    , REPLICATE('B', 1000)
    , REPLICATE('C', 1000)
    , REPLICATE('D', 1000)
    , REPLICATE('E', 1000)
    , REPLICATE('F', 1000)
    , REPLICATE('G', 1000)
    , REPLICATE('H', 1000)
    , REPLICATE('I', 1000)
    , REPLICATE('J', 1000)
    );

    这里我们创建一个表来保存DBCC IND输出，并填充该表：

    DECLARE @fileID int;
DECLARE @pageID int;
DECLARE @slotID int
DECLARE @cmd nvarchar(max);

IF OBJECT_ID(N'dbo.IndexDetails', N'U') IS NOT NULL
DROP TABLE dbo.IndexDetails;
CREATE TABLE dbo.IndexDetails 
(
      PageFID int NULL
    , PagePID int NULL
    , IAMFID int NULL
    , IAMPID int NULL
    , ObjectID int NULL
    , IndexID int NULL
    , PartitionNumber int NULL
    , PartitionID bigint NULL
    , iam_chain_type varchar(100) NULL
    , PageType int NULL
    , IndexLevel int NULL
    , NextPageFID int NULL
    , NextPagePID int NULL
    , PrevPageFID int NULL
    , PrevPagePID int NULL
) ON [PRIMARY];

SET @cmd = 'DBCC IND (''tempdb'', ''dbo.WidthTest'', 1);';
INSERT INTO dbo.IndexDetails 
(
      PageFID 
    , PagePID 
    , IAMFID 
    , IAMPID 
    , ObjectID
    , IndexID 
    , PartitionNumber
    , PartitionID
    , iam_chain_type
    , PageType
    , IndexLevel
    , NextPageFID
    , NextPagePID
    , PrevPageFID
    , PrevPagePID
)
EXEC sys.sp_executesql @cmd;

    最后，此游标遍历表的内容，dbo.IndexDetails显示表使用的每个页面的页面内容：

    DBCC TRACEON (3604); /* send DBCC PAGE output to the client (messages tab) */
DECLARE cur CURSOR LOCAL FORWARD_ONLY STATIC
FOR
SELECT PageFID, PagePID
FROM dbo.IndexDetails id
WHERE id.PageType IN (1, 3, 4) /* data pages, and text pages */;
OPEN cur;
FETCH NEXT FROM cur INTO @fileID, @pageID;
WHILE @@FETCH_STATUS = 0
BEGIN
    DBCC PAGE (tempdb, @fileID, @pageID, 1)
    FETCH NEXT FROM cur INTO @fileID, @pageID;
END
CLOSE cur;
DEALLOCATE cur;
DBCC TRACEOFF (3604); /* send DBCC PAGE output to the error log (default) */

    游标的有趣输出位显示在 SSMS 的“消息”选项卡上。

    这是第一页。注意Record Type = PRIMARY_RECORD：

    页：（1:319464）

缓冲：

BUF @0x0000000203A1C0C0

bpage = 0x000000017018E000 bhash = 0x0000000000000000 bpageno = (1:319464)
bdbid = 2 参考 = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 950 bstat = 0x10b
博客 = 0x212121cc bnext = 0x0000000000000000          

页眉：

页面@0x000000017018E000

m_pageId = (1:319464) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000
m_objId (AllocUnitId.idObj) = 178209m_indexId (AllocUnitId.idInd) = 7680
元数据：AllocUnitId = 2161727832816943104                              
元数据：PartitionId = 1152921515708121088 元数据：IndexId = 0
元数据：ObjectId = 1013578649 m_prevPage = (0:0) m_nextPage = (0:0)
pminlen = 4 m_slotCnt = 1 m_freeCnt = 992
m_freeData = 7198 m_reservedCnt = 0 m_lsn = (60:220956:448)
m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
m_tornBits = 0 数据库片段 ID = 1                      

分配状态

GAM (1:2) = 已分配 SGAM (1:3) = 未分配          
PFS (1:315432) = 0x43 已分配 95_PCT_FULL 差异 (1:6) = 未更改
ML (1:7) = NOT MIN_LOGGED           

数据：


插槽 0，偏移量 0x60，长度 7102，DumpStyle BYTE

记录类型 = PRIMARY_RECORD 记录属性 = NULL_BITMAP VARIABLE_COLUMNS
记录大小 = 7102                  
内存转储 @0x000000000DBAA060

0000000000000000：0......ü..6.NfN6。
0000000000000014: ....î.Ö.¾.......>
0000000000000028：..è...àß......
000000000000003C：..我...è...àß........
0000000000000050：......2_..è...àß....
0000000000000064：..DDDDDDDDDDDDDDDDDD
0000000000000078：DDDDDDDDDDDDDDDDDDDD
000000000000008C：DDDDDDDDDDDDDDDDDDDD
00000000000000A0：DDDDDDDDDDDDDDDDDDDD
00000000000000B4：DDDDDDDDDDDDDDDDDDDD
00000000000000C8：DDDDDDDDDDDDDDDDDDDD
00000000000000DC：DDDDDDDDDDDDDDDDDDDD
00000000000000F0：DDDDDDDDDDDDDDDDDDDD
0000000000000104：DDDDDDDDDDDDDDDDDDDD
0000000000000118：DDDDDDDDDDDDDDDDDDDD
000000000000012C：DDDDDDDDDDDDDDDDDDDD
0000000000000140：DDDDDDDDDDDDDDDDDDDD
0000000000000154：DDDDDDDDDDDDDDDDDDDD
0000000000000168：DDDDDDDDDDDDDDDDDDDD
000000000000017C：DDDDDDDDDDDDDDDDDDDD
0000000000000190：DDDDDDDDDDDDDDDDDDDD
00000000000001A4：DDDDDDDDDDDDDDDDDDDD
00000000000001B8：DDDDDDDDDDDDDDDDDDDD
00000000000001抄送：DDDDDDDDDDDDDDDDDDDD
00000000000001E0：DDDDDDDDDDDDDDDDDDDD
00000000000001F4：DDDDDDDDDDDDDDDDDDDD
0000000000000208：DDDDDDDDDDDDDDDDDDDD
000000000000021C：DDDDDDDDDDDDDDDDDDDD
0000000000000230：DDDDDDDDDDDDDDDDDDDD
0000000000000244：DDDDDDDDDDDDDDDDDDDD
0000000000000258：DDDDDDDDDDDDDDDDDDDD
000000000000026C：DDDDDDDDDDDDDDDDDDDD
0000000000000280：DDDDDDDDDDDDDDDDDDDD
0000000000000294：DDDDDDDDDDDDDDDDDDDD
00000000000002A8：DDDDDDDDDDDDDDDDDDDD
00000000000002BC：DDDDDDDDDDDDDDDDDDDD
00000000000002D0：DDDDDDDDDDDDDDDDDDDD
00000000000002E4：DDDDDDDDDDDDDDDDDDDD
00000000000002F8：DDDDDDDDDDDDDDDDDDDD
000000000000030C：DDDDDDDDDDDDDDDDDDDD
0000000000000320：DDDDDDDDDDDDDDDDDDDD
0000000000000334：DDDDDDDDDDDDDDDDDDDD
0000000000000348：DDDDDDDDDDDDDDDDDDDD
000000000000035C：DDDDDDDDDDDDDDDDDDDD
0000000000000370：DDDDDDDDDDDDDDDDDDDD
0000000000000384：DDDDDDDDDDDDDDDDDDDD
0000000000000398：DDDDDDDDDDDDDDDDDDDD
00000000000003AC：DDDDDDDDDDDDDDDDDDDD
00000000000003C0：DDDDDDDDDDDDDDDDDDDD
00000000000003D4：DDDDDDDDDDDDDDDDDDDD
00000000000003E8：DDDDDDDDDDDDDDDDDDDD
00000000000003FC：DDDDDDDDDDDDDDDDDDDD
0000000000000410：DDDDDDDDDDDDDDDDDDDD
0000000000000424：DDDDDDDDDDDDDDDDDDDD
0000000000000438：DDDDDDDDDDDDDDDDDDDD
000000000000044C：DDEEEEEEEEEEEEEEEEEEEEEE
0000000000000460：EEEEEEEEEEEEEEEEEEEEEE
0000000000000474：EEEEEEEEEEEEEEEEEEEEEE
0000000000000488：EEEEEEEEEEEEEEEEEEEEEE
000000000000049C：EEEEEEEEEEEEEEEEEEEEEE
00000000000004B0：EEEEEEEEEEEEEEEEEEEEEE
00000000000004C4：EEEEEEEEEEEEEEEEEEEEEE
00000000000004D8：EEEEEEEEEEEEEEEEEEEEEE
00000000000004EC：EEEEEEEEEEEEEEEEEEEEEE
0000000000000500：EEEEEEEEEEEEEEEEEEEEEE
0000000000000514：EEEEEEEEEEEEEEEEEEEEEE
0000000000000528：EEEEEEEEEEEEEEEEEEEEEE
000000000000053C：EEEEEEEEEEEEEEEEEEEEEE
0000000000000550：EEEEEEEEEEEEEEEEEEEEEE
0000000000000564：EEEEEEEEEEEEEEEEEEEEEE
0000000000000578：EEEEEEEEEEEEEEEEEEEEEE
000000000000058C：EEEEEEEEEEEEEEEEEEEEEE
00000000000005A0：EEEEEEEEEEEEEEEEEEEEEE
00000000000005B4：EEEEEEEEEEEEEEEEEEEEEE
00000000000005C8：EEEEEEEEEEEEEEEEEEEEEE
00000000000005DC：EEEEEEEEEEEEEEEEEEEEEE
00000000000005F0：EEEEEEEEEEEEEEEEEEEEEE
0000000000000604：EEEEEEEEEEEEEEEEEEEEEE
0000000000000618：EEEEEEEEEEEEEEEEEEEEEE
000000000000062C：EEEEEEEEEEEEEEEEEEEEEE
0000000000000640：EEEEEEEEEEEEEEEEEEEEEE
0000000000000654：EEEEEEEEEEEEEEEEEEEEEE
0000000000000668：EEEEEEEEEEEEEEEEEEEEEE
000000000000067C：EEEEEEEEEEEEEEEEEEEEEE
0000000000000690：EEEEEEEEEEEEEEEEEEEEEE
00000000000006A4：EEEEEEEEEEEEEEEEEEEEEE
00000000000006B8：EEEEEEEEEEEEEEEEEEEEEE
00000000000006抄送：EEEEEEEEEEEEEEEEEEEEEE
00000000000006E0：EEEEEEEEEEEEEEEEEEEEEE
00000000000006F4：EEEEEEEEEEEEEEEEEEEEEE
0000000000000708：EEEEEEEEEEEEEEEEEEEEEE
000000000000071C：EEEEEEEEEEEEEEEEEEEEEE
0000000000000730：EEEEEEEEEEEEEEEEEEEEEE
0000000000000744：EEEEEEEEEEEEEEEEEEEEEE
0000000000000758：EEEEEEEEEEEEEEEEEEEEEE
000000000000076C：EEEEEEEEEEEEEEEEEEEEEE
0000000000000780：EEEEEEEEEEEEEEEEEEEEEE
0000000000000794：EEEEEEEEEEEEEEEEEEEEEE
00000000000007A8：EEEEEEEEEEEEEEEEEEEEEE
00000000000007BC：EEEEEEEEEEEEEEEEEEEEEE
00000000000007D0：EEEEEEEEEEEEEEEEEEEEEE
00000000000007E4：EEEEEEEEEEEEEEEEEEEEEE
00000000000007F8：EEEEEEEEEEEEEEEEEEEEEE
000000000000080C：EEEEEEEEEEEEEEEEEEEEEE
0000000000000820：EEEEEEEEEEEEEEEEEEEEEE
0000000000000834：EEFFFFFFFFFFFFFFFFFFFF
0000000000000848：FFFFFFFFFFFFFFFFFFFFFF
000000000000085C：FFFFFFFFFFFFFFFFFFFFFF
0000000000000870：FFFFFFFFFFFFFFFFFFFFFF
0000000000000884：FFFFFFFFFFFFFFFFFFFFFF
0000000000000898：FFFFFFFFFFFFFFFFFFFFFF
00000000000008AC：FFFFFFFFFFFFFFFFFFFF
00000000000008C0：FFFFFFFFFFFFFFFFFFFFFF
00000000000008D4：FFFFFFFFFFFFFFFFFFFFFF
00000000000008E8：FFFFFFFFFFFFFFFFFFFFFF
00000000000008FC：FFFFFFFFFFFFFFFFFFFF
0000000000000910：FFFFFFFFFFFFFFFFFFFFFF
0000000000000924：FFFFFFFFFFFFFFFFFFFFFF
0000000000000938：FFFFFFFFFFFFFFFFFFFFFF
000000000000094C：FFFFFFFFFFFFFFFFFFFFFF
0000000000000960：FFFFFFFFFFFFFFFFFFFFFF
0000000000000974：FFFFFFFFFFFFFFFFFFFFFF
0000000000000988：FFFFFFFFFFFFFFFFFFFFFF
000000000000099C: FFFFFFFFFFFFFFFFFFFFFF
00000000000009B0：FFFFFFFFFFFFFFFFFFFFFF
00000000000009C4：FFFFFFFFFFFFFFFFFFFFFF
00000000000009D8：FFFFFFFFFFFFFFFFFFFFFF
00000000000009EC：FFFFFFFFFFFFFFFFFFFF
0000000000000A00：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A14：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A28：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A3C：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A50：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A64：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A78：FFFFFFFFFFFFFFFFFFFFFF
0000000000000A8C：FFFFFFFFFFFFFFFFFFFFFF
0000000000000AA0：FFFFFFFFFFFFFFFFFFFF
0000000000000AB4：FFFFFFFFFFFFFFFFFFFF
0000000000000AC8：FFFFFFFFFFFFFFFFFFFF
0000000000000ADC：FFFFFFFFFFFFFFFFFFFF
0000000000000AF0：FFFFFFFFFFFFFFFFFFFF
0000000000000B04：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B18：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B2C：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B40：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B54：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B68：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B7C：FFFFFFFFFFFFFFFFFFFFFF
0000000000000B90：FFFFFFFFFFFFFFFFFFFFFF
0000000000000BA4：FFFFFFFFFFFFFFFFFFFF
0000000000000BB8：FFFFFFFFFFFFFFFFFFFF
0000000000000密件抄送：FFFFFFFFFFFFFFFFFFFF
0000000000000BE0：FFFFFFFFFFFFFFFFFFFFFF
0000000000000BF4：FFFFFFFFFFFFFFFFFFFFFF
0000000000000C08：FFFFFFFFFFFFFFFFFFFFFF
0000000000000C1C：FFGGGGGGGGGGGGGGGGG
0000000000000C30：GGGGGGGGGGGGGGGGGGG
0000000000000C44：GGGGGGGGGGGGGGGGGGG
0000000000000C58：GGGGGGGGGGGGGGGGGGG
0000000000000C6C：GGGGGGGGGGGGGGGGGGG
0000000000000C80：GGGGGGGGGGGGGGGGGGG
0000000000000C94：GGGGGGGGGGGGGGGGGGG
0000000000000CA8：GGGGGGGGGGGGGGGGGGG
0000000000000CBC：GGGGGGGGGGGGGGGGGGG
0000000000000CD0：GGGGGGGGGGGGGGGGGGG
0000000000000E38：GGGGGGGGGGGGGGGGGGG
0000000000000E4C：GGGGGGGGGGGGGGGGGGG
0000000000000E60：GGGGGGGGGGGGGGGGGGG
0000000000000E74：GGGGGGGGGGGGGGGGGGG
0000000000000E88：GGGGGGGGGGGGGGGGGGG
0000000000000E9C：GGGGGGGGGGGGGGGGGGG
0000000000000EB0：GGGGGGGGGGGGGGGGGGG
0000000000000EC4：GGGGGGGGGGGGGGGGGGG
0000000000000ED8：GGGGGGGGGGGGGGGGGGG
0000000000000EEC：GGGGGGGGGGGGGGGGGGG
0000000000000F00：GGGGGGGGGGGGGGGGGGG
0000000000000F78：GGGGGGGGGGGGGGGGGGG
0000000000000F8C：GGGGGGGGGGGGGGGGGGG
0000000000000FA0：GGGGGGGGGGGGGGGGGGG
0000000000000FB4：GGGGGGGGGGGGGGGGGGG
0000000000000FC8：GGGGGGGGGGGGGGGGGGG
0000000000000FDC：GGGGGGGGGGGGGGGGGGGG
0000000000000FF0：GGGGGGGGGGGGGGGGGGG
0000000000001004：GGHHHHHHHHHHHHHHHHHH
0000000000001018：HHHHHHHHHHHHHHHHHHHH
000000000000102C：HHHHHHHHHHHHHHHHHHHH
0000000000001040：哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈
0000000000001054：哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈
0000000000001194：HHHHHHHHHHHHHHHHHHHH
00000000000011A8：HHHHHHHHHHHHHHHHHHHH
00000000000011BC：HHHHHHHHHHHHHHHHHHHH
00000000000011D0：HHHHHHHHHHHHHHHHHHHH
00000000000011E4：HHHHHHHHHHHHHHHHHHHH
00000000000011F8：HHHHHHHHHHHHHHHHHHHH
000000000000120C：HHHHHHHHHHHHHHHHHHHH
0000000000001220：HHHHHHHHHHHHHHHHHHHH
0000000000001234：HHHHHHHHHHHHHHHHHHHH
0000000000001248：HHHHHHHHHHHHHHHHHHHH
000000000000125C：HHHHHHHHHHHHHHHHHHHH
0000000000001270：HHHHHHHHHHHHHHHHHHHH
0000000000001284：哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈
0000000000001298：HHHHHHHHHHHHHHHHHHHH
00000000000012AC：HHHHHHHHHHHHHHHHHHHH
00000000000012C0：HHHHHHHHHHHHHHHHHHHH
00000000000012D4：HHHHHHHHHHHHHHHHHHHH
00000000000012E8：HHHHHHHHHHHHHHHHHHHH
00000000000012FC：HHHHHHHHHHHHHHHHHHHH
0000000000001310：HHHHHHHHHHHHHHHHHHHH
0000000000001324：HHHHHHHHHHHHHHHHHHHH
0000000000001338：HHHHHHHHHHHHHHHHHHHH
000000000000134C：HHHHHHHHHHHHHHHHHHHH
0000000000001360：哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈
0000000000001374：HHHHHHHHHHHHHHHHHHHH
0000000000001388：
000000000000139C：HHHHHHHHHHHHHHHHHHHH
00000000000013B0：HHHHHHHHHHHHHHHHHHHH
00000000000013C4：HHHHHHHHHHHHHHHHHHHH
00000000000013D8：HHHHHHHHHHHHHHHHHHHH
00000000000013EC: HHIIIIIIIIIIIIIIIIIIIII
0000000000001400：
0000000000001414：
0000000000001428：
000000000000143C：
0000000000001450：
0000000000001464：
0000000000001478：
000000000000148C：
00000000000014A0：IIIIIIIIIIIIIIIIIIIIIIII
00000000000014B4：IIIIIIIIIIIIIIIIIIIII
00000000000014C8：IIIIIIIIIIIIIIIIIIIII
00000000000014DC: IIIIIIIIIIIIIIIIIIIIIII
00000000000014F0：IIIIIIIIIIIIIIIIIIIIIIII
0000000000001504：
0000000000001518：
000000000000152C：
0000000000001540：
0000000000001554：
0000000000001568：
000000000000157C：
0000000000001590：
00000000000015A4：IIIIIIIIIIIIIIIIIIIII
00000000000015B8：
00000000000015抄送：IIIIIIIIIIIIIIIIIIIII
00000000000015E0：
00000000000015F4：IIIIIIIIIIIIIIIIIIIIIIII
0000000000001608：
000000000000161C：
0000000000001630：
0000000000001644：
0000000000001658：
000000000000166C：
0000000000001680：
0000000000001694：
00000000000016A8：
00000000000016BC：IIIIIIIIIIIIIIIIIIIII
00000000000016D0：IIIIIIIIIIIIIIIIIIIIIIII
00000000000016E4：
00000000000016F8：IIIIIIIIIIIIIIIIIIIIIIII
000000000000170C：IIIIIIIIIIIIIIIIIIIIIIII
0000000000001720：
0000000000001734：
0000000000001748：
000000000000175C：
0000000000001770：
0000000000001784：
0000000000001798：
00000000000017AC：IIIIIIIIIIIIIIIIIIIIIIII
00000000000017C0：IIIIIIIIIIIIIIIIIIIIIIII
00000000000017D4：IIJJJJJJJJJJJJJJJJJJ
00000000000017E8：JJJJJJJJJJJJJJJJJJJJ
00000000000017FC: JJJJJJJJJJJJJJJJJJJJ
0000000000001810：JJJJJJJJJJJJJJJJJJJJ
0000000000001824：JJJJJJJJJJJJJJJJJJJJ
0000000000001838：JJJJJJJJJJJJJJJJJJJJ
000000000000184C：JJJJJJJJJJJJJJJJJJJJ
0000000000001860：JJJJJJJJJJJJJJJJJJJJ
0000000000001874：JJJJJJJJJJJJJJJJJJJJ
0000000000001888：JJJJJJJJJJJJJJJJJJJJ
000000000000189C：JJJJJJJJJJJJJJJJJJJJ
00000000000018B0：JJJJJJJJJJJJJJJJJJJJ
00000000000018C4：JJJJJJJJJJJJJJJJJJJJ
00000000000018D8：JJJJJJJJJJJJJJJJJJJJ
00000000000018EC: JJJJJJJJJJJJJJJJJJJJ
0000000000001900：JJJJJJJJJJJJJJJJJJJJ
0000000000001914：JJJJJJJJJJJJJJJJJJJJ
0000000000001928：JJJJJJJJJJJJJJJJJJJJ
000000000000193C：JJJJJJJJJJJJJJJJJJJJ
0000000000001950：JJJJJJJJJJJJJJJJJJJJ
0000000000001964：JJJJJJJJJJJJJJJJJJJJ
0000000000001978：JJJJJJJJJJJJJJJJJJJJ
000000000000198C：JJJJJJJJJJJJJJJJJJJJ
00000000000019A0：JJJJJJJJJJJJJJJJJJJJ
00000000000019B4：JJJJJJJJJJJJJJJJJJJJ
00000000000019C8：JJJJJJJJJJJJJJJJJJJJ
00000000000019DC：JJJJJJJJJJJJJJJJJJJJ
00000000000019F0：JJJJJJJJJJJJJJJJJJJJ
0000000000001A04：JJJJJJJJJJJJJJJJJJJJ
0000000000001A18：JJJJJJJJJJJJJJJJJJJJ
0000000000001A2C：JJJJJJJJJJJJJJJJJJJJ
0000000000001A40：JJJJJJJJJJJJJJJJJJJJ
0000000000001A54：JJJJJJJJJJJJJJJJJJJJ
0000000000001A68：JJJJJJJJJJJJJJJJJJJJ
0000000000001A7C：JJJJJJJJJJJJJJJJJJJJ
0000000000001A90：JJJJJJJJJJJJJJJJJJJJ
0000000000001AA4：JJJJJJJJJJJJJJJJJJJJ
0000000000001AB8：JJJJJJJJJJJJJJJJJJJJ
0000000000001ACC：JJJJJJJJJJJJJJJJJJJJ
0000000000001AE0：JJJJJJJJJJJJJJJJJJJJ
0000000000001AF4：JJJJJJJJJJJJJJJJJJJJ
0000000000001B08：JJJJJJJJJJJJJJJJJJJJ
0000000000001B1C：JJJJJJJJJJJJJJJJJJJJ
0000000000001B30：JJJJJJJJJJJJJJJJJJJJ
0000000000001B44：JJJJJJJJJJJJJJJJJJJJ
0000000000001B58：JJJJJJJJJJJJJJJJJJJJ
0000000000001B6C：JJJJJJJJJJJJJJJJJJJJ
0000000000001B80：JJJJJJJJJJJJJJJJJJJJ
0000000000001B94：JJJJJJJJJJJJJJJJJJJJ
0000000000001BA8：JJJJJJJJJJJJJJJJJJJJ
0000000000001BBC：JJ     

偏移表：

行 - 偏移                        
0 (0x0) - 96 (0x60)                 


DBCC 执行完成。如果 DBCC 打印出错误消息，请联系您的系统管理员。

    我已经删除了实际页面转储的十六进制内容，以将我的帖子保持在 30,000 个字符的限制之内。正如您从上面的页面转储中看到的那样，我的示例中的主页面不包含前 3 列，A它们存储在行溢出区域中，如下所示，B其中：CRecord Type = BLOB_FRAGMENT

    页：（1:319456）

缓冲：

BUF @0x0000000203A19240

bpage = 0x0000000170186000          bhash = 0x0000000000000000          bpageno = (1:319456)
bdbid = 2                           breferences = 0                     bcputicks = 0
bsampleCount = 0                    bUse1 = 950                         bstat = 0x10b
blog = 0x1212121c                   bnext = 0x0000000000000000          

PAGE HEADER:


Page @0x0000000170186000

m_pageId = (1:319456)               m_headerVersion = 1                 m_type = 3
m_typeFlagBits = 0x0                m_level = 0                         m_flagBits = 0x8000
m_objId (AllocUnitId.idObj) = 178834m_indexId (AllocUnitId.idInd) = 7936
Metadata: AllocUnitId = 2233785426895831040                              
Metadata: PartitionId = 1152921515708121088                              Metadata: IndexId = 0
Metadata: ObjectId = 1013578649     m_prevPage = (0:0)                  m_nextPage = (0:0)
pminlen = 0                         m_slotCnt = 3                       m_freeCnt = 5048
m_freeData = 3166                   m_reservedCnt = 0                   m_lsn = (60:220956:430)
m_xactReserved = 0                  m_xdesId = (0:0)                    m_ghostRecCnt = 0
m_tornBits = 0                      DB Frag ID = 1                      

Allocation Status

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

DATA:


Slot 0, Offset 0x60, Length 1014, DumpStyle BYTE

Record Type = BLOB_FRAGMENT         Record Attributes =                 Record Size = 1014

Memory Dump @0x000000000DBAA060

0000000000000000:  ..ö....>......AAAAAA
0000000000000014:  AAAAAAAAAAAAAAAAAAAA
0000000000000028:  AAAAAAAAAAAAAAAAAAAA
000000000000003C:  AAAAAAAAAAAAAAAAAAAA
0000000000000050:  AAAAAAAAAAAAAAAAAAAA
0000000000000064:  AAAAAAAAAAAAAAAAAAAA
0000000000000078:  AAAAAAAAAAAAAAAAAAAA
000000000000008C:  AAAAAAAAAAAAAAAAAAAA
00000000000000A0:  AAAAAAAAAAAAAAAAAAAA
00000000000000B4:  AAAAAAAAAAAAAAAAAAAA
00000000000000C8:  AAAAAAAAAAAAAAAAAAAA
00000000000000DC:  AAAAAAAAAAAAAAAAAAAA
00000000000000F0:  AAAAAAAAAAAAAAAAAAAA
0000000000000104:  AAAAAAAAAAAAAAAAAAAA
0000000000000118:  AAAAAAAAAAAAAAAAAAAA
000000000000012C:  AAAAAAAAAAAAAAAAAAAA
0000000000000140:  AAAAAAAAAAAAAAAAAAAA
0000000000000154:  AAAAAAAAAAAAAAAAAAAA
0000000000000168:  AAAAAAAAAAAAAAAAAAAA
000000000000017C:  AAAAAAAAAAAAAAAAAAAA
0000000000000190:  AAAAAAAAAAAAAAAAAAAA
00000000000001A4:  AAAAAAAAAAAAAAAAAAAA
00000000000001B8:  AAAAAAAAAAAAAAAAAAAA
00000000000001CC:  AAAAAAAAAAAAAAAAAAAA
00000000000001E0:  AAAAAAAAAAAAAAAAAAAA
00000000000001F4:  AAAAAAAAAAAAAAAAAAAA
0000000000000208:  AAAAAAAAAAAAAAAAAAAA
000000000000021C:  AAAAAAAAAAAAAAAAAAAA
0000000000000230:  AAAAAAAAAAAAAAAAAAAA
0000000000000244:  AAAAAAAAAAAAAAAAAAAA
0000000000000258:  AAAAAAAAAAAAAAAAAAAA
000000000000026C:  AAAAAAAAAAAAAAAAAAAA
0000000000000280:  AAAAAAAAAAAAAAAAAAAA
0000000000000294:  AAAAAAAAAAAAAAAAAAAA
00000000000002A8:  AAAAAAAAAAAAAAAAAAAA
00000000000002BC:  AAAAAAAAAAAAAAAAAAAA
00000000000002D0:  AAAAAAAAAAAAAAAAAAAA
00000000000002E4:  AAAAAAAAAAAAAAAAAAAA
00000000000002F8:  AAAAAAAAAAAAAAAAAAAA
000000000000030C:  AAAAAAAAAAAAAAAAAAAA
0000000000000320:  AAAAAAAAAAAAAAAAAAAA
0000000000000334:  AAAAAAAAAAAAAAAAAAAA
0000000000000348:  AAAAAAAAAAAAAAAAAAAA
000000000000035C:  AAAAAAAAAAAAAAAAAAAA
0000000000000370:  AAAAAAAAAAAAAAAAAAAA
0000000000000384:  AAAAAAAAAAAAAAAAAAAA
0000000000000398:  AAAAAAAAAAAAAAAAAAAA
00000000000003AC:  AAAAAAAAAAAAAAAAAAAA
00000000000003C0:  AAAAAAAAAAAAAAAAAAAA
00000000000003D4:  AAAAAAAAAAAAAAAAAAAA
00000000000003E8:  AAAAAAAAAAAAAA


Slot 1, Offset 0x464, Length 1014, DumpStyle BYTE

Record Type = BLOB_FRAGMENT         Record Attributes =                 Record Size = 1014

Memory Dump @0x000000000DBAA464

0000000000000000:  ..ö...I.......BBBBBB
0000000000000014:  BBBBBBBBBBBBBBBBBBBB
0000000000000028:  BBBBBBBBBBBBBBBBBBBB
000000000000003C:  BBBBBBBBBBBBBBBBBBBB
0000000000000050:  BBBBBBBBBBBBBBBBBBBB
0000000000000064:  BBBBBBBBBBBBBBBBBBBB
0000000000000078:  BBBBBBBBBBBBBBBBBBBB
000000000000008C:  BBBBBBBBBBBBBBBBBBBB
00000000000000A0:  BBBBBBBBBBBBBBBBBBBB
00000000000000B4:  BBBBBBBBBBBBBBBBBBBB
00000000000000C8:  BBBBBBBBBBBBBBBBBBBB
00000000000000DC:  BBBBBBBBBBBBBBBBBBBB
00000000000000F0:  BBBBBBBBBBBBBBBBBBBB
0000000000000104:  BBBBBBBBBBBBBBBBBBBB
0000000000000118:  BBBBBBBBBBBBBBBBBBBB
000000000000012C:  BBBBBBBBBBBBBBBBBBBB
0000000000000140:  BBBBBBBBBBBBBBBBBBBB
0000000000000154:  BBBBBBBBBBBBBBBBBBBB
0000000000000168:  BBBBBBBBBBBBBBBBBBBB
000000000000017C:  BBBBBBBBBBBBBBBBBBBB
0000000000000190:  BBBBBBBBBBBBBBBBBBBB
00000000000001A4:  BBBBBBBBBBBBBBBBBBBB
00000000000001B8:  BBBBBBBBBBBBBBBBBBBB
00000000000001CC:  BBBBBBBBBBBBBBBBBBBB
00000000000001E0:  BBBBBBBBBBBBBBBBBBBB
00000000000001F4:  BBBBBBBBBBBBBBBBBBBB
0000000000000208:  BBBBBBBBBBBBBBBBBBBB
000000000000021C:  BBBBBBBBBBBBBBBBBBBB
0000000000000230:  BBBBBBBBBBBBBBBBBBBB
0000000000000244:  BBBBBBBBBBBBBBBBBBBB
0000000000000258:  BBBBBBBBBBBBBBBBBBBB
000000000000026C:  BBBBBBBBBBBBBBBBBBBB
0000000000000280:  BBBBBBBBBBBBBBBBBBBB
0000000000000294:  BBBBBBBBBBBBBBBBBBBB
00000000000002A8:  BBBBBBBBBBBBBBBBBBBB
00000000000002BC:  BBBBBBBBBBBBBBBBBBBB
00000000000002D0:  BBBBBBBBBBBBBBBBBBBB
00000000000002E4:  BBBBBBBBBBBBBBBBBBBB
00000000000002F8:  BBBBBBBBBBBBBBBBBBBB
000000000000030C:  BBBBBBBBBBBBBBBBBBBB
0000000000000320:  BBBBBBBBBBBBBBBBBBBB
0000000000000334:  BBBBBBBBBBBBBBBBBBBB
0000000000000348:  BBBBBBBBBBBBBBBBBBBB
000000000000035C:  BBBBBBBBBBBBBBBBBBBB
0000000000000370:  BBBBBBBBBBBBBBBBBBBB
0000000000000384:  BBBBBBBBBBBBBBBBBBBB
0000000000000398:  BBBBBBBBBBBBBBBBBBBB
00000000000003AC:  BBBBBBBBBBBBBBBBBBBB
00000000000003C0:  BBBBBBBBBBBBBBBBBBBB
00000000000003D4:  BBBBBBBBBBBBBBBBBBBB
00000000000003E8:  BBBBBBBBBBBBBB

Slot 2, Offset 0x868, Length 1014, DumpStyle BYTE

Record Type = BLOB_FRAGMENT         Record Attributes =                 Record Size = 1014

Memory Dump @0x000000000DBAA868

0000000000000000:   ..ö...2_......CCCCCC
0000000000000014:   CCCCCCCCCCCCCCCCCCCC
0000000000000028:   CCCCCCCCCCCCCCCCCCCC
000000000000003C:   CCCCCCCCCCCCCCCCCCCC
0000000000000050:   CCCCCCCCCCCCCCCCCCCC
0000000000000064:   CCCCCCCCCCCCCCCCCCCC
0000000000000078:   CCCCCCCCCCCCCCCCCCCC
000000000000008C:   CCCCCCCCCCCCCCCCCCCC
00000000000000A0:   CCCCCCCCCCCCCCCCCCCC
00000000000000B4:   CCCCCCCCCCCCCCCCCCCC
00000000000000C8:   CCCCCCCCCCCCCCCCCCCC
00000000000000DC:   CCCCCCCCCCCCCCCCCCCC
00000000000000F0:   CCCCCCCCCCCCCCCCCCCC
0000000000000104:   CCCCCCCCCCCCCCCCCCCC
0000000000000118:   CCCCCCCCCCCCCCCCCCCC
000000000000012C:   CCCCCCCCCCCCCCCCCCCC
0000000000000140:   CCCCCCCCCCCCCCCCCCCC
0000000000000154:   CCCCCCCCCCCCCCCCCCCC
0000000000000168:   CCCCCCCCCCCCCCCCCCCC
000000000000017C:   CCCCCCCCCCCCCCCCCCCC
0000000000000190:   CCCCCCCCCCCCCCCCCCCC
00000000000001A4:   CCCCCCCCCCCCCCCCCCCC
00000000000001B8:   CCCCCCCCCCCCCCCCCCCC
00000000000001CC:   CCCCCCCCCCCCCCCCCCCC
00000000000001E0:   CCCCCCCCCCCCCCCCCCCC
00000000000001F4:   CCCCCCCCCCCCCCCCCCCC
0000000000000208:   CCCCCCCCCCCCCCCCCCCC
000000000000021C:   CCCCCCCCCCCCCCCCCCCC
0000000000000230:   CCCCCCCCCCCCCCCCCCCC
0000000000000244:   CCCCCCCCCCCCCCCCCCCC
0000000000000258:   CCCCCCCCCCCCCCCCCCCC
000000000000026C:   CCCCCCCCCCCCCCCCCCCC
0000000000000280:   CCCCCCCCCCCCCCCCCCCC
0000000000000294:   CCCCCCCCCCCCCCCCCCCC
00000000000002A8:   CCCCCCCCCCCCCCCCCCCC
00000000000002BC:   CCCCCCCCCCCCCCCCCCCC
00000000000002D0:   CCCCCCCCCCCCCCCCCCCC
00000000000002E4:   CCCCCCCCCCCCCCCCCCCC
00000000000002F8:   CCCCCCCCCCCCCCCCCCCC
000000000000030C:   CCCCCCCCCCCCCCCCCCCC
0000000000000320:   CCCCCCCCCCCCCCCCCCCC
0000000000000334:   CCCCCCCCCCCCCCCCCCCC
0000000000000348:   CCCCCCCCCCCCCCCCCCCC
000000000000035C:   CCCCCCCCCCCCCCCCCCCC
0000000000000370:   CCCCCCCCCCCCCCCCCCCC
0000000000000384:   CCCCCCCCCCCCCCCCCCCC
0000000000000398:   CCCCCCCCCCCCCCCCCCCC
00000000000003AC:   CCCCCCCCCCCCCCCCCCCC
00000000000003C0:   CCCCCCCCCCCCCCCCCCCC
00000000000003D4:   CCCCCCCCCCCCCCCCCCCC
00000000000003E8:   CCCCCCCCCCCCCC
    • 4

相关问题