Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Непонятный момент с PFS страницами  [new]
rere1234
Member

Откуда:
Сообщений: 38
Доброе время суток уважаемые форумчане, прошу помочь в закавыке на которую я напоролся в процессе изучения Sql Server, в частности информации PFS страниц.

Итак диспозиция:

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


Генерирую данные, сразу предупреждаю что fillfactor по умолчанию для бд я не менял:

drop table aaa
create table aaa (id chAR(36) primary key, name char(1000))
go
insert into aaa(id, name) values(newid(), REPLICATE('0', 1000))
go 10000


Достаю список allocated_page_page_id страниц с уровня листьев
select allocated_page_page_id from 
sys.dm_db_database_page_allocations(db_id(), object_id('dbo.aaa'), null, null, 
'DETAILED')
where page_type_desc = 'DATA_PAGE'


В результате около 2000 страниц, выбираю из них allocated_page_page_id = 2117

Открываю ее с помощью команды DBCC PAGE:
DBCC TRACEON(3604)
GO
DBCC PAGE (0, 1, 2117, 3)
GO



+
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (1:2117)


BUFFER:


BUF @0x00000001FFDEAB00

bpage = 0x000000012CF3E000 bhash = 0x0000000000000000 bpageno = (1:2117)
bdbid = 6 breferences = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 34979 bstat = 0x20009
blog = 0x15ab215a bnext = 0x0000000000000000

PAGE HEADER:


Page @0x000000012CF3E000

m_pageId = (1:2117) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2200
m_objId (AllocUnitId.idObj) = 21260 m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057595431223296
Metadata: PartitionId = 72057595427291136 Metadata: IndexId = 1
Metadata: ObjectId = 2118350661 m_prevPage = (1:2916) m_nextPage = (1:2384)
pminlen = 1040 m_slotCnt = 7 m_freeCnt = 683
m_freeData = 7495 m_reservedCnt = 0 m_lsn = (8536:9376:2)
m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
m_tornBits = -707062674 DB Frag ID = 1

Allocation Status

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

Slot 0 Offset 0x60 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70A060

0000000000000000: 50001004 30453439 42313839 2d343545 392d3443 P...0E49B189-45E9-4C
0000000000000014: 36312d41 4632392d 30354138 32344444 31373233 61-AF29-05A824DD1723
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 000000b5 61160001 00 ...........µa....

Version Information =
Transaction Timestamp: 4296434101
Version Pointer: Null


Slot 0 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E49B189-45E9-4C61-AF29-05A824DD1723

Slot 0 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 0 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (c7bed908b1dc)
Slot 1 Offset 0x10e4 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70B0E4

0000000000000000: 50001004 30453442 34324144 2d463731 312d3446 P...0E4B42AD-F711-4F
0000000000000014: 37372d39 3844462d 38333639 39323237 45344445 77-98DF-83699227E4DE
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 000000f1 7a160001 00 ...........ñz....

Version Information =
Transaction Timestamp: 4296440561
Version Pointer: Null


Slot 1 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E4B42AD-F711-4F77-98DF-83699227E4DE

Slot 1 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 1 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (40dc8682ebd9)
Slot 2 Offset 0x1926 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70B926

0000000000000000: 50001004 30453445 36304236 2d343132 322d3446 P...0E4E60B6-4122-4F
0000000000000014: 45422d39 3741382d 46373536 32443242 46323536 EB-97A8-F7562D2BF256
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 0000006d 8a160001 00 ...........mŠ....

Version Information =
Transaction Timestamp: 4296444525
Version Pointer: Null


Slot 2 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E4E60B6-4122-4FEB-97A8-F7562D2BF256

Slot 2 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 2 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (e4fc2ada3269)
Slot 3 Offset 0xcc3 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70ACC3

0000000000000000: 50001004 30453636 44303934 2d303231 352d3432 P...0E66D094-0215-42
0000000000000014: 35322d41 4432382d 37364243 46373843 38464542 52-AD28-76BCF78C8FEB
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 000000d5 7a160001 00 ...........Õz....

Version Information =
Transaction Timestamp: 4296440533
Version Pointer: Null


Slot 3 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E66D094-0215-4252-AD28-76BCF78C8FEB

Slot 3 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 3 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (f0aa0a6d770a)
Slot 4 Offset 0x8a2 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70A8A2

0000000000000000: 50001004 30453743 42424141 2d363042 312d3441 P...0E7CBBAA-60B1-4A
0000000000000014: 43362d42 3535332d 35463331 43383443 32374343 C6-B553-5F31C84C27CC
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 0000008a 76160001 00 ...........Šv....

Version Information =
Transaction Timestamp: 4296439434
Version Pointer: Null


Slot 4 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E7CBBAA-60B1-4AC6-B553-5F31C84C27CC

Slot 4 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 4 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (e95c6a941aa8)
Slot 5 Offset 0x481 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70A481

0000000000000000: 50001004 30453839 33333236 2d464238 442d3445 P...0E893326-FB8D-4E
0000000000000014: 41342d42 3145422d 35393344 39453532 35343443 A4-B1EB-593D9E52544C
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 00000014 68160001 00 ............h....

Version Information =
Transaction Timestamp: 4296435732
Version Pointer: Null


Slot 5 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E893326-FB8D-4EA4-B1EB-593D9E52544C

Slot 5 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 5 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (e9d1e02e45cd)
Slot 6 Offset 0x1505 Length 1057

Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VERSIONING_INFO
Record Size = 1057
Memory Dump @0x000000000D70B505

0000000000000000: 50001004 30453842 34333539 2d413232 392d3439 P...0E8B4359-A229-49
0000000000000014: 34362d39 3835302d 41364134 41313931 31464645 46-9850-A6A4A1911FFE
0000000000000028: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000003C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000050: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000064: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000078: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000008C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000A0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000B4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000C8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000DC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000000F0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000104: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000118: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000012C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000140: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000154: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000168: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000017C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000190: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001A4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001B8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001CC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001E0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000001F4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000208: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000021C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000230: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000244: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000258: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000026C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000280: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000294: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002A8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002BC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002D0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002E4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000002F8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000030C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000320: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000334: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000348: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
000000000000035C: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000370: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000384: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000398: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003AC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003C0: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003D4: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003E8: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
00000000000003FC: 30303030 30303030 30303030 30303030 30303030 00000000000000000000
0000000000000410: 02000000 00000000 0000009e 7d160001 00 ...........ž}....

Version Information =
Transaction Timestamp: 4296441246
Version Pointer: Null


Slot 6 Column 1 Offset 0x4 Length 36 Length (physical) 36

id = 0E8B4359-A229-4946-9850-A6A4A1911FFE

Slot 6 Column 2 Offset 0x28 Length 1000 Length (physical) 1000

name = 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Slot 6 Offset 0x0 Length 0 Length (physical) 0

KeyHashValue = (0ace63f0ed2e)


DBCC execution completed. If DBCC printed error messages, contact your system administrator.


И что же я вижу :
PFS (1:1) = 0x40 ALLOCATED 0_PCT_FULL

при том что число свободных байт на странице m_freeCnt = 683

Прилогаю также вывод команды DBCC PAGE - PFS страницы выбранной страницы (dbcc page (0, 1, 1, 3)):

+

PAGE: (1:1)


BUFFER:


BUF @0x00000001FF9BC0C0

bpage = 0x0000000139772000 bhash = 0x0000000000000000 bpageno = (1:1)
bdbid = 6 breferences = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 35193 bstat = 0x20009
blog = 0x15ab215a bnext = 0x0000000000000000

PAGE HEADER:


Page @0x0000000139772000

m_pageId = (1:1) m_headerVersion = 1 m_type = 11
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x200
m_objId (AllocUnitId.idObj) = 99 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 6488064
Metadata: PartitionId = 0 Metadata: IndexId = 0 Metadata: ObjectId = 99
m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0
m_slotCnt = 1 m_freeCnt = 2 m_freeData = 8188
m_reservedCnt = 0 m_lsn = (8536:22504:9) m_xactReserved = 0
m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = -1826881505
DB Frag ID = 1

Allocation Status

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

PFS: Page Alloc Status @0x0000000011C6A000

(1:0) - (1:3) = ALLOCATED 100_PCT_FULL
(1:4) - (1:5) = NOT ALLOCATED 0_PCT_FULL
(1:6) - (1:7) = ALLOCATED 100_PCT_FULL
(1:8) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:9) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:10) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:11) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:12) - = ALLOCATED 100_PCT_FULL IAM Page Mixed Ext
(1:13) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:14) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:15) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:16) - (1:17) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:18) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:19) - (1:20) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:21) - (1:22) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:23) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:24) - (1:31) = ALLOCATED 0_PCT_FULL
(1:32) - = ALLOCATED 50_PCT_FULL Mixed Ext
(1:33) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:34) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:35) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:36) - (1:38) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:39) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:40) - (1:44) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:45) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:46) - (1:48) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:49) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:50) - (1:54) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:55) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:56) - (1:61) = ALLOCATED 0_PCT_FULL
(1:62) - = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:63) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:64) - (1:71) = ALLOCATED 0_PCT_FULL
(1:72) - (1:75) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:76) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:77) - (1:80) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:81) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:82) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:83) - (1:84) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:85) - (1:87) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:88) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:89) - (1:91) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:92) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:93) - (1:95) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:96) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:97) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:98) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:99) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:100) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:101) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:102) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:103) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:104) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:105) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:106) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:107) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:108) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:109) - (1:113) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:114) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:115) - (1:116) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:117) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:118) - (1:120) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:121) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:122) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:123) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:124) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:125) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:126) - (1:128) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:129) - (1:131) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:132) - (1:133) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:134) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:135) - (1:136) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:137) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:138) - (1:140) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:141) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:142) - (1:143) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:144) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:145) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:146) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:147) - (1:149) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:150) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:151) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:152) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:153) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:154) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:155) - (1:156) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:157) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:158) - (1:165) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:166) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:167) - (1:168) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:169) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:170) - (1:171) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:172) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:173) - (1:176) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:177) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:178) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:179) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:180) - (1:183) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:184) - (1:195) = ALLOCATED 0_PCT_FULL
(1:196) - (1:199) = NOT ALLOCATED 0_PCT_FULL
(1:200) - = ALLOCATED 0_PCT_FULL
(1:201) - (1:207) = NOT ALLOCATED 0_PCT_FULL
(1:208) - (1:223) = ALLOCATED 0_PCT_FULL
(1:224) - (1:226) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:227) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:228) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:229) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:230) - (1:231) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:232) - (1:247) = ALLOCATED 0_PCT_FULL
(1:248) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:249) - (1:252) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:253) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:254) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:255) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:256) - (1:263) = ALLOCATED 0_PCT_FULL
(1:264) - (1:265) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:266) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:267) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:268) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:269) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:270) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:271) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:272) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:273) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:274) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:275) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:276) - (1:278) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:279) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:280) - (1:296) = ALLOCATED 0_PCT_FULL
(1:297) - (1:303) = NOT ALLOCATED 0_PCT_FULL
(1:304) - (1:312) = ALLOCATED 0_PCT_FULL
(1:313) - (1:319) = NOT ALLOCATED 0_PCT_FULL
(1:320) - (1:334) = ALLOCATED 0_PCT_FULL
(1:335) - = NOT ALLOCATED 0_PCT_FULL
(1:336) - (1:360) = ALLOCATED 0_PCT_FULL
(1:361) - (1:367) = NOT ALLOCATED 0_PCT_FULL
(1:368) - (1:376) = ALLOCATED 0_PCT_FULL
(1:377) - (1:383) = NOT ALLOCATED 0_PCT_FULL
(1:384) - (1:407) = ALLOCATED 0_PCT_FULL
(1:408) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:409) - = ALLOCATED 50_PCT_FULL Mixed Ext
(1:410) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:411) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:412) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:413) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:414) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:415) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:416) - (1:684) = ALLOCATED 0_PCT_FULL
(1:685) - (1:687) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:688) - (1:729) = ALLOCATED 0_PCT_FULL
(1:730) - (1:735) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:736) - (1:820) = NOT ALLOCATED 0_PCT_FULL
(1:821) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:822) - (1:951) = NOT ALLOCATED 0_PCT_FULL
(1:952) - (1:1026) = ALLOCATED 0_PCT_FULL
(1:1027) - (1:1031) = NOT ALLOCATED 0_PCT_FULL
(1:1032) - (1:1045) = ALLOCATED 0_PCT_FULL
(1:1046) - (1:1047) = NOT ALLOCATED 0_PCT_FULL
(1:1048) - (1:1058) = ALLOCATED 0_PCT_FULL
(1:1059) - (1:1063) = NOT ALLOCATED 0_PCT_FULL
(1:1064) - (1:1074) = ALLOCATED 0_PCT_FULL
(1:1075) - (1:1079) = NOT ALLOCATED 0_PCT_FULL
(1:1080) - (1:1081) = ALLOCATED 0_PCT_FULL
(1:1082) - (1:1095) = NOT ALLOCATED 0_PCT_FULL
(1:1096) - (1:3235) = ALLOCATED 0_PCT_FULL
(1:3236) - (1:4967) = NOT ALLOCATED 0_PCT_FULL
(1:4968) - (1:4975) = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:4976) - (1:8087) = NOT ALLOCATED 0_PCT_FULL


DBCC execution completed. If DBCC printed error messages, contact your system administrator.


и лог DBCC CHECKDB
+
DBCC results for 'Test'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for 'sys.sysrscols'.
There are 71657 rows in 541 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 13235 rows in 106 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysclones'.
There are 0 rows in 0 pages for object "sys.sysclones".
DBCC results for 'sys.sysallocunits'.
There are 13249 rows in 125 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 4 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.sysseobjvalues'.
There are 0 rows in 0 pages for object "sys.sysseobjvalues".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysdbfrag'.
There are 0 rows in 0 pages for object "sys.sysdbfrag".
DBCC results for 'sys.sysfgfrag'.
There are 0 rows in 0 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.syspru'.
There are 0 rows in 0 pages for object "sys.syspru".
DBCC results for 'sys.sysbrickfiles'.
There are 0 rows in 0 pages for object "sys.sysbrickfiles".
DBCC results for 'sys.sysphfg'.
There are 3 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 4 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysdbreg'.
There are 0 rows in 0 pages for object "sys.sysdbreg".
DBCC results for 'sys.sysprivs'.
There are 138 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 2216 rows in 35 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 778 rows in 13 pages for object "sys.syscolpars".
DBCC results for 'sys.sysxlgns'.
There are 0 rows in 0 pages for object "sys.sysxlgns".
DBCC results for 'sys.sysxsrvs'.
There are 0 rows in 0 pages for object "sys.sysxsrvs".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.sysusermsgs'.
There are 0 rows in 0 pages for object "sys.sysusermsgs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysrmtlgns'.
There are 0 rows in 0 pages for object "sys.sysrmtlgns".
DBCC results for 'sys.syslnklgns'.
There are 0 rows in 0 pages for object "sys.syslnklgns".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 2 rows in 1 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 227 rows in 3 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 417 rows in 2 pages for object "sys.sysiscols".
DBCC results for 'sys.sysendpts'.
There are 0 rows in 0 pages for object "sys.sysendpts".
DBCC results for 'sys.syswebmethods'.
There are 0 rows in 0 pages for object "sys.syswebmethods".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 2928 rows in 48 pages for object "sys.sysobjvalues".
DBCC results for 'sys.syscscolsegments'.
There are 0 rows in 0 pages for object "sys.syscscolsegments".
DBCC results for 'sys.syscsdictionaries'.
There are 0 rows in 0 pages for object "sys.syscsdictionaries".
DBCC results for 'sys.sysclsobjs'.
There are 22 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 13095 rows in 58 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 5426 rows in 22 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 134 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 2 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysfoqueues'.
There are 0 rows in 0 pages for object "sys.sysfoqueues".
DBCC results for 'sys.syschildinsts'.
There are 0 rows in 0 pages for object "sys.syschildinsts".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftsemanticsdb'.
There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysftproperties'.
There are 0 rows in 0 pages for object "sys.sysftproperties".
DBCC results for 'sys.sysxmitbody'.
There are 0 rows in 0 pages for object "sys.sysxmitbody".
DBCC results for 'sys.sysfos'.
There are 0 rows in 0 pages for object "sys.sysfos".
DBCC results for 'sys.sysqnames'.
There are 98 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 100 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 19 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 5 rows in 1 pages for object "sys.syssoftobjrefs".
DBCC results for 'testsize'.
There are 2000 rows in 5 pages for object "testsize".
DBCC results for 'Region'.
There are 1 rows in 1 pages for object "Region".
DBCC results for 'Post'.
There are 50 rows in 1 pages for object "Post".
DBCC results for 'Direction'.
There are 8 rows in 1 pages for object "Direction".
DBCC results for 'bbb'.
There are 1000 rows in 5 pages for object "bbb".
DBCC results for 'Apk'.
There are 128 rows in 1 pages for object "Apk".
DBCC results for 'Camera'.
There are 258 rows in 2 pages for object "Camera".
DBCC results for 'Traffic1'.
There are 61000000 rows in 415120 pages for object "Traffic1".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'test001'.
There are 1 rows in 2 pages for object "test001".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'sys.filetable_updates_2105058535'.
There are 0 rows in 0 pages for object "sys.filetable_updates_2105058535".
DBCC results for 'aaa'.
There are 10000 rows in 2131 pages for object "aaa".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Test'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Пожалуйста помогите разобраться в чем моя ошибка, где я не так смотрю.
5 янв 15, 06:09    [17086087]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
o-o
Guest
rere1234,

а вы специально такой ПК выбрали гуидообразный, чтобы побольше страниц насплитить, да?
вот и огребли. посмотрите порядок страниц, хоть бы две подряд шли
5 янв 15, 11:32    [17086265]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
o-o
Guest
вот так будет все честно:
create table bbb (id uniqueidentifier DEFAULT NEWSEQUENTIALID() primary key, name char(1000))
go
insert into bbb(name) values(REPLICATE('0', 1000))
go 10000

select count(*) as cnt
from sys.dm_db_database_page_allocations(db_id(), object_id('dbo.bbb'), null, null, 'DETAILED')
where page_type_desc = 'DATA_PAGE'
---
cnt
1429

select 10000. / 7 as [должно быть страниц данных]
---
должно быть страниц данных
1428.571428
5 янв 15, 11:54    [17086286]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
rere1234
Member

Откуда:
Сообщений: 38
o-o,

Спасибо за замечание, но это же не отменяет факта несоответствия информации PFS, и да я выбрал гуидное поле увеличения числа страниц на нелистьевом уровне (для дальнейших опытов)
5 янв 15, 12:26    [17086356]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
o-o
Guest
простите, можете еще раз вопрос сформулировать? что с чем не сходится?
мне показалось, вас удивил "получившийся" FF для таблицы,
rere1234
сразу предупреждаю что fillfactor по умолчанию для бд я не менял

но вы явно что-то другое спрашиваете
5 янв 15, 12:53    [17086403]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
invm
Member

Откуда: Москва
Сообщений: 9845
rere1234,

Перечитайте для каких случаев в PFS отслеживается заполненность страницы. Вот скрипт вам в помощь:
+
use tempdb;
go

if object_id('dbo.t', 'U') is not null
 drop table dbo.t;

create table dbo.t (id int identity, filler char(500));
--create table dbo.t (id int identity primary key, filler char(500));
declare @t table (ParentObject varchar(255), Object varchar(255), Field varchar(255), VALUE varchar(255));

insert into dbo.t select top (4) 'a' from master.dbo.spt_values;

declare @s varchar(8000), @p int

select top (1)
 @p = allocated_page_page_id
from 
 sys.dm_db_database_page_allocations(db_id(), object_id('dbo.t'), null, null, 'DETAILED')
where
 page_type_desc = 'DATA_PAGE';

select 
 @s = 'dbcc page(' + cast(db_id() as varchar(10)) + ', 1, ' + cast(1 + @p / 8088 as varchar(10)) + ', 3) with tableresults;';

delete from @t;
insert into @t
 exec(@s);
select * from @t where Field like '%:' + cast(@p as varchar(10)) + ')%';
 
insert into dbo.t select top (4) 'a' from master.dbo.spt_values;
delete from @t;
insert into @t
 exec(@s);
select * from @t where Field like '%:' + cast(@p as varchar(10)) + ')%';
 
insert into dbo.t select top (4) 'a' from master.dbo.spt_values;
delete from @t;
insert into @t
 exec(@s);
select * from @t where Field like '%:' + cast(@p as varchar(10)) + ')%';

insert into dbo.t select top (4) 'a' from master.dbo.spt_values;
delete from @t;
insert into @t
 exec(@s);
select * from @t where Field like '%:' + cast(@p as varchar(10)) + ')%';

drop table dbo.t;
go
Выполните, когда таблица - куча, и когда у нее есть кластерный индекс.
5 янв 15, 12:54    [17086405]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
o-o
Guest
аааа, теперь до меня вроде дошло, вы все про что :)
invm, спасибо.
rere1234, да, просто нет смысла отслеживать для кластерного свободное пространство.
для кучи -- да, ведь новую запись надо бы куда-то приткнуть. куда? где есть свободное место. поэтому его отслеживают.
для кластерного выбора просто нет: место, куда ляжет запись, однозначно определено ее ключом, поэтому зачем следить за тем, чего нaм все равно :)
5 янв 15, 13:02    [17086417]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
rere1234
Member

Откуда:
Сообщений: 38
Всем спасибо огромное за ответы. Как я понел sql server не считает нужным отслеживать процентное заполнение кластерных листьев а ориентируется только на число байт, так как страницу куда будет вставляться запись он знает.
5 янв 15, 14:13    [17086538]     Ответить | Цитировать Сообщить модератору
 Re: Непонятный момент с PFS страницами  [new]
o-o
Guest
rere1234,

вот MS-овское видео, где сие подписано, словами со слуха там такое:

The free space tracking is only done, as it says there, for heap data pages and for text pages because these are the only kind of pages where SQL Server has a choice of where to put a particular record. Where index is our concern (index pages and data pages in clustered indexes) there is no choice about where to put a particular record. The insertion point in the index is bounded by the index key value itself, so there's no point tracking free space for any other kind of pages apart from heap data pages and text pages.

К сообщению приложен файл. Размер - 143Kb
5 янв 15, 23:04    [17087855]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить