- 浏览: 275032 次
文章分类
最新评论
-
feargod:
...
ActivityGroup的子activity响应back事件的顺序问题 -
hoarhoar:
谢谢你,终于解决了,我真是受够了,总是45秒钟,真是疯了。
youku 的广告必须要屏蔽 -
lilai:
...
youku 的广告必须要屏蔽 -
aijuans2:
...
youku 的广告必须要屏蔽 -
weiwo1978:
说的非常好,mark
SELECT语句执行的顺序
DBCC使用之:使用DBCC来探索ASE中的索引页及数据页结构
可能要用到的DBCC指令:
1> dbcc help(log)
2> go
log( [dbid | dbname] [,objid | objname] [,page] [,row] [,nrecords] [,type={
-1..84 }] ,printopt={ 0 | 1 | 2 | 3 } [,indid | indname] [,ptnid | ptnname] )
1> dbcc help(page)
2> go
page( dbid|dbname, pagenum [, printopt={0|1|2|3|4} [, cache={0|1} [,
logical={1|0} [, cachename | -1 ]]]] )
1> dbcc help(listoam)
2> go
listoam(dbid | dbname, objid | objname, indid | indname [, ptnid | ptnname [,
cache=[1]{ 1 | 'cache' | 0 | 'disk' } [, printopt=[1]{ 1 | 'verbose' | 0 |
'terse' } ] ] ])
我们用下述SQL来造数据:
1> create table mytest(id int primary key, col2 varchar(512)) 2> go 1> create index idx_mytest_col2 on mytest(col2) 2> go 1> insert into mytest values(1, replicate(char(convert(int, round(rand() * 26, 0) + 65) ), 512)) 2> go (1 row affected) 1> insert into mytest values(2, replicate(char(convert(int, round(rand() * 26, 0) + 65) ), 512)) 2> go (1 row affected) 1> insert into mytest select id + (select max(id) from mytest), replicate(char(convert(int, round(rand() * 26, 0) + 65) ), 512) from mytest 2> go 10 (1024 rows affected) 10 xacts:
Sysindexes系统表的关键列:
以上是准备工作,我们再看看sysindexes的列含义:
id, 表的ID,或者index所属的表的id
indid, 索引ID, 值为0时,它是一个表。为1时,为APL表的聚簇索引(cluster index),>1时,为非聚簇索引或者是DOL表上的聚簇索引
为255时,指代的是LOB结构
doampg, 表的对象分配页上对象的页号
ioampg,索引或者LOB结构的分配页号
first, 如果indid为0或1,数据页的首页号, 如果是2到250,它为页级索引页的第一个页号
root, 如果indid为0, 并且表是未分区的APL表,它是页链的最后一页的页号。如果是1到250之间,它是索引树的根的页号。
Syspartitions的关键列:
indid, id同上。
partitionid, 索引或数据的分区ID
segment,段号
datoampage
indoampage
firstpage
rootpage
含义同上。
获取索引相关信息:
1> select id, indid, doampg, ioampg, first, root from sysindexes where id = object_id('mytest') 2> go id indid doampg ioampg first root ----------- ------ ----------- ----------- ----------- ----------- 960003420 1 0 0 0 0 960003420 2 0 0 0 0 (2 rows affected)
1> select name, indid, segment, datoampage, indoampage, firstpage, rootpage from syspartitions where id = object_id('mytest') 2> go name indid segment datoampage indoampage firstpage rootpage --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ ------- ----------- ----------- ----------- ----------- mytest_id_9600034201_960003420 1 1 968 960 969 961 idx_mytest_col2_960003420 2 1 0 872 874 873 (2 rows affected)
据此分析,索引mytest_id_9600034201_960003420是聚簇索引,首页号为969, 根页号为961.
索引idx_mytest_col2_960003420为非聚簇索引,首页号为874, 根页号为873.
表mytest总共有2048行数据,
1> select count(*) from mytest 2> go ----------- 2048 (1 row affected)
1> select pagesize(object_id('mytest')) 2> go ----------- 4096 (1 row affected)
看看对象分配页的情况:
1> dbcc listoam('iihero', 'mytest', 1) 2> go ----------------------------------------------------------------------------- Partition id: 960003420 indid: 1 prevpg: 960 nextpg: 960 OAM pg cnt: 1 Entry cnt: 1 Row count information is not maintained for index pages. Used pgs: 2 Unused pgs: 6 Attribute entries: 10 OAM status bits set: (0x8000 (PG_OAMPG), 0x0008 (PG_OAMATTRIB), 0x0004 (PG_OAMSORT)) LAST SCANNED OAM PAGE: 0 ALLOCATION HINTS : 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OAM pg # 1: 960 has the following 1 entry (allocpg:used/unused): [ 0] 768: 2/ 6 ---- End of OAM chain for partition 960003420 ----
1> dbcc listoam('iihero', 'mytest', 2) 2> go ----------------------------------------------------------------------------- Partition id: 960003420 indid: 2 prevpg: 872 nextpg: 872 OAM pg cnt: 1 Entry cnt: 8 Row count information is not maintained for index pages. Used pgs: 576 Unused pgs: 6 Attribute entries: 10 OAM status bits set: (0x8000 (PG_OAMPG), 0x0008 (PG_OAMATTRIB)) LAST SCANNED OAM PAGE: 0 ALLOCATION HINTS : 872 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OAM pg # 1: 872 has the following 8 entries (allocpg:used/unused): [ 0] 768: 24/ 0 1024: 88/ 0 1280: 72/ 0 1536:111/ 0 [ 4] 1792: 48/ 0 2048:104/ 0 2304:104/ 0 2560:25/ 6 ---- End of OAM chain for partition 960003420 ----
以普通索引2为例,
1> dbcc page('iihero', 873, 1) 2> go Page found in Cache: default data cache. Cachelet: 1 BUFFER: Buffer header for buffer 0x22D55000 page=0x22D54000 bdnew=0x23588550 bdold=0x23588550 bhash=0x23587E00 bmass_next=0x23588310 bmass_prev=0x23596C80 bdbid=4 bvirtpg=[ 0x22D55078 vpgdevno=5 vpvpn=1746 vdisk=0x214E04C8 ] bmass_head=0x23588550 bmass_tail=0x23588550 bcache_desc=0x22D57C00 (cid=0 cache name='default data cache') bpool_desc=0x22D59BF4 bdbtable=0x20EBBC60 Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0 bmass_size=4096 (4K pool) bunref_cnt=0 bmass_stat=0x86001010(0x0000000080000000 (MASS_FLUSHED), 0x0000000004000000 (MASS_DONT_DISCARD), 0x0000000002000000 (MASS_WRITE_BY_HK), 0x0000000000001000 (MASS_HASHED), 0x0000000000000010 (MASS_INWASH)) bbuf_stat=0x1 (0x00000001 (BUF_PG_REF)) Buffer blpageno=873 bpg_size=4k Mass blpageno=873 Mass blocallockkeep=0 bxls_pin=0x00000000 bxls_next=0x00000000 bspid=0 bxls_flushseq=0 bxls_pinseq=0 bcurrxdes=0x00000000 Latch and the wait queue: Latch (address: 0x22D55024) latchmode: 0x0 (FREE_LATCH) latchstatus: 0x0 latchowner: -1 latchnoofowners: 0 latchwaitq: 0x00000000 latchwaitqt: 0x00000000 latchlastfileindex=0 (nofilename) latchlastlineno=0 Latch wait queue: PAGE HEADER: Page header for page 0x22D54000 pageno=873 nextpg=0 prevpg=0 ptnid=960003420 timestamp=0000 000039b3 lastrowoff=2677 level=4 indid=2 freeoff=3206 minlen=11 page status bits: 0x1000 (0x1000 (PG_OFFSET)) DATA: Offset 32 - row length=529 # varlen cols=1 Child page ID=1482 22D54020 ( 0): 01c90300 000200ca 05000011 02464646 .............FFF 22D54030 ( 16): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54040 ( 32): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54050 ( 48): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54060 ( 64): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54070 ( 80): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54080 ( 96): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54090 ( 112): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D540A0 ( 128): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D540B0 ( 144): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D540C0 ( 160): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D540D0 ( 176): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D540E0 ( 192): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D540F0 ( 208): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54100 ( 224): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54110 ( 240): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54120 ( 256): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54130 ( 272): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54140 ( 288): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54150 ( 304): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54160 ( 320): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54170 ( 336): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54180 ( 352): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54190 ( 368): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D541A0 ( 384): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D541B0 ( 400): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D541C0 ( 416): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D541D0 ( 432): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D541E0 ( 448): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D541F0 ( 464): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54200 ( 480): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54210 ( 496): 46464646 46464646 46464646 46464646 FFFFFFFFFFFFFFFF 22D54220 ( 512): 46464646 46464646 46464646 4602020d FFFFFFFFFFFFF... 22D54230 ( 528): 0d . Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 13, 512] Offset 561 - row length=529 # varlen cols=1 Child page ID=2505 22D54231 ( 0): 01ca0300 000100c9 09000011 02444444 .............DDD 22D54241 ( 16): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54251 ( 32): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54261 ( 48): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54271 ( 64): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54281 ( 80): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54291 ( 96): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542A1 ( 112): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542B1 ( 128): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542C1 ( 144): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542D1 ( 160): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542E1 ( 176): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542F1 ( 192): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54301 ( 208): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54311 ( 224): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54321 ( 240): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54331 ( 256): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54341 ( 272): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54351 ( 288): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54361 ( 304): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54371 ( 320): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54381 ( 336): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54391 ( 352): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543A1 ( 368): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543B1 ( 384): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543C1 ( 400): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543D1 ( 416): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543E1 ( 432): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543F1 ( 448): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54401 ( 464): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54411 ( 480): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54421 ( 496): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54431 ( 512): 44444444 44444444 44444444 4402020d DDDDDDDDDDDDD... 22D54441 ( 528): 0d . Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 13, 512] Offset 1090 - row length=529 # varlen cols=1 Child page ID=1483 22D54442 ( 0): 01cf0300 000000cb 05000011 02494949 .............III 22D54452 ( 16): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54462 ( 32): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54472 ( 48): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54482 ( 64): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54492 ( 80): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D544A2 ( 96): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D544B2 ( 112): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D544C2 ( 128): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D544D2 ( 144): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D544E2 ( 160): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D544F2 ( 176): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54502 ( 192): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54512 ( 208): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54522 ( 224): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54532 ( 240): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54542 ( 256): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54552 ( 272): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54562 ( 288): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54572 ( 304): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54582 ( 320): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54592 ( 336): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D545A2 ( 352): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D545B2 ( 368): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D545C2 ( 384): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D545D2 ( 400): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D545E2 ( 416): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D545F2 ( 432): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54602 ( 448): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54612 ( 464): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54622 ( 480): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54632 ( 496): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54642 ( 512): 49494949 49494949 49494949 4902020d IIIIIIIIIIIII... 22D54652 ( 528): 0d . Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 13, 512] Offset 1619 - row length=529 # varlen cols=1 Child page ID=2586 22D54653 ( 0): 01c80400 0006001a 0a000011 024c4c4c .............LLL 22D54663 ( 16): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54673 ( 32): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54683 ( 48): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54693 ( 64): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D546A3 ( 80): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D546B3 ( 96): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D546C3 ( 112): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D546D3 ( 128): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D546E3 ( 144): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D546F3 ( 160): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54703 ( 176): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54713 ( 192): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54723 ( 208): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54733 ( 224): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54743 ( 240): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54753 ( 256): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54763 ( 272): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54773 ( 288): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54783 ( 304): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54793 ( 320): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D547A3 ( 336): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D547B3 ( 352): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D547C3 ( 368): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D547D3 ( 384): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D547E3 ( 400): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D547F3 ( 416): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54803 ( 432): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54813 ( 448): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54823 ( 464): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54833 ( 480): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54843 ( 496): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c4c4c4c LLLLLLLLLLLLLLLL 22D54853 ( 512): 4c4c4c4c 4c4c4c4c 4c4c4c4c 4c02020d LLLLLLLLLLLLL... 22D54863 ( 528): 0d . Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 13, 512] Offset 2148 - row length=529 # varlen cols=1 Child page ID=1760 22D54864 ( 0): 01ca0300 000200e0 06000011 02505050 .............PPP 22D54874 ( 16): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54884 ( 32): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54894 ( 48): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D548A4 ( 64): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D548B4 ( 80): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D548C4 ( 96): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D548D4 ( 112): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D548E4 ( 128): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D548F4 ( 144): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54904 ( 160): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54914 ( 176): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54924 ( 192): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54934 ( 208): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54944 ( 224): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54954 ( 240): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54964 ( 256): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54974 ( 272): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54984 ( 288): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54994 ( 304): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D549A4 ( 320): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D549B4 ( 336): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D549C4 ( 352): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D549D4 ( 368): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D549E4 ( 384): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D549F4 ( 400): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A04 ( 416): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A14 ( 432): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A24 ( 448): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A34 ( 464): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A44 ( 480): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A54 ( 496): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54A64 ( 512): 50505050 50505050 50505050 5002020d PPPPPPPPPPPPP... 22D54A74 ( 528): 0d . Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 13, 512] Offset 2677 - row length=529 # varlen cols=1 Child page ID=2162 22D54A75 ( 0): 011c0400 00050072 08000011 02555555 .......r.....UUU 22D54A85 ( 16): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54A95 ( 32): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54AA5 ( 48): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54AB5 ( 64): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54AC5 ( 80): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54AD5 ( 96): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54AE5 ( 112): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54AF5 ( 128): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B05 ( 144): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B15 ( 160): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B25 ( 176): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B35 ( 192): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B45 ( 208): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B55 ( 224): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B65 ( 240): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B75 ( 256): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B85 ( 272): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54B95 ( 288): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54BA5 ( 304): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54BB5 ( 320): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54BC5 ( 336): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54BD5 ( 352): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54BE5 ( 368): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54BF5 ( 384): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C05 ( 400): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C15 ( 416): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C25 ( 432): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C35 ( 448): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C45 ( 464): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C55 ( 480): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C65 ( 496): 55555555 55555555 55555555 55555555 UUUUUUUUUUUUUUUU 22D54C75 ( 512): 55555555 55555555 55555555 5502020d UUUUUUUUUUUUU... 22D54C85 ( 528): 0d . Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 13, 512]
这里我们可以看得很清楚,
Row-Offset table for variable-length columns:
[<varcol number>, <offset from start of the row>, <varcol length>]
[1, 13, 512]
从第14个字节开始,512个字节的长度为col2的值,一下子就可以看出来了。 不再解释。
前13个字节,应该是存储着字段id的值。待分析。
我们如果接着分析1> dbcc page('iihero', 1696, 1)
就会得到它的子节点,跑到数据页上了。 Offset 32 - row length=525 # varlen cols=1 Data page RID=(1668, 2), 不再列举。
此数据页1668的内容如下:
1> dbcc page('iihero', 1668, 1) 2> go Page found in Cache: default data cache. Cachelet: 1 BUFFER: Buffer header for buffer 0x22D55000 page=0x22D54000 bdnew=0x235A16F0 bdold=0x235A16F0 bhash=0x235785F0 bmass_next=0x235A2AA0 bmass_prev=0x235785F0 bdbid=4 bvirtpg=[ 0x22D55078 vpgdevno=5 vpvpn=3336 vdisk=0x214E04C8 ] bmass_head=0x235A16F0 bmass_tail=0x235A16F0 bcache_desc=0x22D57C00 (cid=0 cache name='default data cache') bpool_desc=0x22D59BF4 bdbtable=0x20EBBC60 Mass bkeep=0 Mass bpawaited=0 Mass btripsleft=0 Mass btripsleft_orig=0 bmass_size=4096 (4K pool) bunref_cnt=0 bmass_stat=0x6001010(0x0000000004000000 (MASS_DONT_DISCARD), 0x0000000002000000 (MASS_WRITE_BY_HK), 0x0000000000001000 (MASS_HASHED), 0x0000000000000010 (MASS_INWASH)) bbuf_stat=0x1 (0x00000001 (BUF_PG_REF)) Buffer blpageno=1668 bpg_size=4k Mass blpageno=1668 Mass blocallockkeep=0 bxls_pin=0x00000000 bxls_next=0x00000000 bspid=0 bxls_flushseq=0 bxls_pinseq=0 bcurrxdes=0x00000000 Latch and the wait queue: Latch (address: 0x22D55024) latchmode: 0x0 (FREE_LATCH) latchstatus: 0x0 latchowner: -1 latchnoofowners: 0 latchwaitq: 0x00000000 latchwaitqt: 0x00000000 latchlastfileindex=0 (nofilename) latchlastlineno=0 Latch wait queue: PAGE HEADER: Page header for page 0x22D54000 pageno=1668 nextpg=1669 prevpg=1667 ptnid=960003420 timestamp=0000 000026fc nextrno=7 level=0 indid=0 freeoff=3700 minlen=6 page status bits: 0x101 (0x0100 (PG_ADDEND), 0x0001 (PG_DATA)) DATA: Offset 32 - row ID=0 row length=524 # varlen cols=1 22D54020 ( 0): 01005e03 00000c02 50505050 50505050 ..^.....PPPPPPPP 22D54030 ( 16): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54040 ( 32): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54050 ( 48): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54060 ( 64): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54070 ( 80): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54080 ( 96): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54090 ( 112): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D540A0 ( 128): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D540B0 ( 144): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D540C0 ( 160): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D540D0 ( 176): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D540E0 ( 192): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D540F0 ( 208): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54100 ( 224): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54110 ( 240): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54120 ( 256): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54130 ( 272): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54140 ( 288): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54150 ( 304): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54160 ( 320): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54170 ( 336): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54180 ( 352): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54190 ( 368): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D541A0 ( 384): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D541B0 ( 400): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D541C0 ( 416): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D541D0 ( 432): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D541E0 ( 448): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D541F0 ( 464): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54200 ( 480): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54210 ( 496): 50505050 50505050 50505050 50505050 PPPPPPPPPPPPPPPP 22D54220 ( 512): 50505050 50505050 02020808 PPPPPPPP.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] Offset 556 - row ID=1 row length=524 # varlen cols=1 22D5422C ( 0): 01015f03 00000c02 44444444 44444444 .._.....DDDDDDDD 22D5423C ( 16): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5424C ( 32): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5425C ( 48): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5426C ( 64): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5427C ( 80): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5428C ( 96): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5429C ( 112): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542AC ( 128): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542BC ( 144): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542CC ( 160): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542DC ( 176): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542EC ( 192): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D542FC ( 208): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5430C ( 224): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5431C ( 240): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5432C ( 256): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5433C ( 272): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5434C ( 288): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5435C ( 304): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5436C ( 320): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5437C ( 336): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5438C ( 352): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5439C ( 368): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543AC ( 384): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543BC ( 400): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543CC ( 416): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543DC ( 432): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543EC ( 448): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D543FC ( 464): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5440C ( 480): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5441C ( 496): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D5442C ( 512): 44444444 44444444 02020808 DDDDDDDD.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] Offset 1080 - row ID=2 row length=524 # varlen cols=1 22D54438 ( 0): 01026003 00000c02 44444444 44444444 ..`.....DDDDDDDD 22D54448 ( 16): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54458 ( 32): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54468 ( 48): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54478 ( 64): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54488 ( 80): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54498 ( 96): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D544A8 ( 112): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D544B8 ( 128): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D544C8 ( 144): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D544D8 ( 160): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D544E8 ( 176): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D544F8 ( 192): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54508 ( 208): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54518 ( 224): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54528 ( 240): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54538 ( 256): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54548 ( 272): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54558 ( 288): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54568 ( 304): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54578 ( 320): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54588 ( 336): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54598 ( 352): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D545A8 ( 368): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D545B8 ( 384): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D545C8 ( 400): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D545D8 ( 416): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D545E8 ( 432): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D545F8 ( 448): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54608 ( 464): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54618 ( 480): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54628 ( 496): 44444444 44444444 44444444 44444444 DDDDDDDDDDDDDDDD 22D54638 ( 512): 44444444 44444444 02020808 DDDDDDDD.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] Offset 1604 - row ID=3 row length=524 # varlen cols=1 22D54644 ( 0): 01036103 00000c02 45454545 45454545 ..a.....EEEEEEEE 22D54654 ( 16): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54664 ( 32): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54674 ( 48): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54684 ( 64): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54694 ( 80): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D546A4 ( 96): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D546B4 ( 112): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D546C4 ( 128): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D546D4 ( 144): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D546E4 ( 160): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D546F4 ( 176): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54704 ( 192): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54714 ( 208): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54724 ( 224): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54734 ( 240): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54744 ( 256): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54754 ( 272): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54764 ( 288): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54774 ( 304): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54784 ( 320): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54794 ( 336): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D547A4 ( 352): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D547B4 ( 368): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D547C4 ( 384): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D547D4 ( 400): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D547E4 ( 416): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D547F4 ( 432): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54804 ( 448): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54814 ( 464): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54824 ( 480): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54834 ( 496): 45454545 45454545 45454545 45454545 EEEEEEEEEEEEEEEE 22D54844 ( 512): 45454545 45454545 02020808 EEEEEEEE.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] Offset 2128 - row ID=4 row length=524 # varlen cols=1 22D54850 ( 0): 01046203 00000c02 54545454 54545454 ..b.....TTTTTTTT 22D54860 ( 16): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54870 ( 32): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54880 ( 48): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54890 ( 64): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D548A0 ( 80): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D548B0 ( 96): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D548C0 ( 112): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D548D0 ( 128): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D548E0 ( 144): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D548F0 ( 160): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54900 ( 176): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54910 ( 192): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54920 ( 208): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54930 ( 224): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54940 ( 240): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54950 ( 256): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54960 ( 272): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54970 ( 288): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54980 ( 304): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54990 ( 320): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D549A0 ( 336): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D549B0 ( 352): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D549C0 ( 368): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D549D0 ( 384): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D549E0 ( 400): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D549F0 ( 416): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54A00 ( 432): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54A10 ( 448): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54A20 ( 464): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54A30 ( 480): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54A40 ( 496): 54545454 54545454 54545454 54545454 TTTTTTTTTTTTTTTT 22D54A50 ( 512): 54545454 54545454 02020808 TTTTTTTT.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] Offset 2652 - row ID=5 row length=524 # varlen cols=1 22D54A5C ( 0): 01056303 00000c02 4f4f4f4f 4f4f4f4f ..c.....OOOOOOOO 22D54A6C ( 16): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54A7C ( 32): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54A8C ( 48): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54A9C ( 64): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54AAC ( 80): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54ABC ( 96): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54ACC ( 112): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54ADC ( 128): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54AEC ( 144): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54AFC ( 160): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B0C ( 176): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B1C ( 192): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B2C ( 208): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B3C ( 224): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B4C ( 240): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B5C ( 256): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B6C ( 272): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B7C ( 288): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B8C ( 304): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54B9C ( 320): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54BAC ( 336): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54BBC ( 352): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54BCC ( 368): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54BDC ( 384): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54BEC ( 400): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54BFC ( 416): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54C0C ( 432): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54C1C ( 448): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54C2C ( 464): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54C3C ( 480): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54C4C ( 496): 4f4f4f4f 4f4f4f4f 4f4f4f4f 4f4f4f4f OOOOOOOOOOOOOOOO 22D54C5C ( 512): 4f4f4f4f 4f4f4f4f 02020808 OOOOOOOO.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] Offset 3176 - row ID=6 row length=524 # varlen cols=1 22D54C68 ( 0): 01066403 00000c02 49494949 49494949 ..d.....IIIIIIII 22D54C78 ( 16): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54C88 ( 32): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54C98 ( 48): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54CA8 ( 64): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54CB8 ( 80): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54CC8 ( 96): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54CD8 ( 112): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54CE8 ( 128): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54CF8 ( 144): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D08 ( 160): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D18 ( 176): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D28 ( 192): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D38 ( 208): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D48 ( 224): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D58 ( 240): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D68 ( 256): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D78 ( 272): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D88 ( 288): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54D98 ( 304): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54DA8 ( 320): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54DB8 ( 336): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54DC8 ( 352): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54DD8 ( 368): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54DE8 ( 384): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54DF8 ( 400): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E08 ( 416): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E18 ( 432): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E28 ( 448): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E38 ( 464): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E48 ( 480): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E58 ( 496): 49494949 49494949 49494949 49494949 IIIIIIIIIIIIIIII 22D54E68 ( 512): 49494949 49494949 02020808 IIIIIIII.... Row-Offset table for variable-length columns: [<varcol number>, <offset from start of the row>, <varcol length>] [1, 8, 512] OFFSET TABLE: Row - Offset 6 (0x06) - 3176 (0x0c68), 5 (0x05) - 2652 (0x0a5c), 4 (0x04) - 2128 (0x0850), 3 (0x03) - 1604 (0x0644), 2 (0x02) - 1080 (0x0438), 1 (0x01) - 556 (0x022c), 0 (0x00) - 32 (0x0020),
这一页,总共有7行数据。00000c02应该是行长度: 524. (020c), 头4个字节,以rowid=0x03为例, 01036103,似乎是第2个字节描述的是rowid. 余下的6103,变成小端0361->dec , 变成865. 经过查询,col2值确实为EEEE(512bytes长)。那么首字节01,到底表示什么呢?
<script type="text/javascript"><!-- google_ad_client = "ca-pub-7104628658411459"; /* wide1 */ google_ad_slot = "8564482570"; google_ad_width = 728; google_ad_height = 90; //--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
相关推荐
dbcc showcontig(@table_id) dbcc dbreindex('[HumanResources].[Employee]',' ',5) DBCC INDEXDEFRAG('ADVENTUREWORKS_DATA','[HumanResources].[Employee]') use ADVENTUREWORKS_DATA set @table_id=...
SQL Server 2005完结篇系列之五:使用DBCC命令来进行数据库的维护及性能调节SQL Server 2005完结篇系列之五:使用DBCC命令来进行数据库的维护及性能调节SQL Server 2005完结篇系列之五:使用DBCC命令来进行数据库的...
SQL Server 2000完结篇系列之五:使用DBCC命令来进行数据库的维护及性能调节
未能在 sysindexes 中找到数据库 ID 12 中对象 ID 1 的索引 ID 1 对应的行。请对 sysindexes 运行 DBCC CHECKTABLE。 这是我自己在设计时遇到的问题,经过自己从很多网站里面看到的知识,总结出来的解决问题!!分享...
SQL Server 2005中的索引架构:抛开DBCC SHOWCONTIG,使用新的函数.pdf
提高SQL Server性能,可通过DBCC DBREINDEX重建索引 提高SQL Server性能,本文将详细介绍DBCC DBREINDEX重建索引的全过程。,详情请看下载 欢迎大家学习! use ADVENTUREWORKS_DATA declare @table_id int set @...
2.51 如何执行optdiag命令来监控表和索引的物理使用情况? 36 2.52 如何执行reorg 系列命令来优化Dol表及其索引? 36 2.53 如何使用sp_sysmon存储过程来查看当前数据库的性能情况? 37 3. 技术专刊 38 3.1 关于...
Transact-SQL 编程语言提供 DBCC 语句作为 SQL Server 的数据库控制台命令。 DBCC 命令使用输入参数并返回值。所有 DBCC 命令参数都可以接受 Unicode 和 DBCS 文字。
2. 为索引指定填充因子,可标识填充因子来指定每个索引页的填满程度。索引页上的空余空间量很重要,因为当索引页填满时,系统必须花时间拆分它以便为新行腾出空间。 优化索引 1. 重建索引(dbcc dbreindex) 2. ...
台湾DB World的电子杂志文章,详细讲述了DBCC的使用,适合DBA管理者,(4/4)
Sql-Server实用操作-数据库一致性检测工具(DBCC).pdf
2.51 如何执行optdiag命令来监控表和索引的物理使用情况? 40 2.52 如何执行reorg 系列命令来优化Dol表及其索引? 41 2.53 如何使用sp_sysmon存储过程来查看当前数据库的性能情况? 41 3. 技术专刊 43 3.1 关于...
在危急时刻,数据库一致性检测(DBCC)可能是你最重要的工具。本文向大家简单介绍DBCC的功能,包括:检测表和相关目录的完整性、检测整个数据库、检测数据库页的完整性、重建任何指定表中的目录。
dbcc. iv Adaptive Server Enterprise deallocate cursor declare . declare cursor delete delete statistics disk init . disk mirror . disk refit. disk reinit . disk remirror . disk resize . disk ...
此文档中详细的记载了,SQL SERVER DBCC命令解释,希望可以帮助到下载的朋友们
所有的DBCC命令数据库修复数据库修复数据库修复数据库修复数据库修复数据库修复
未能在 sysindexes 中找到数据库 ID 11 中对象 ID 1 的索引 ID 1 对应的行。请对 sysindexes 运行 DBCC CHECKTABLE。 Could not find row in sysindexes for database ID 11, object ID 1, index ID 1. Run DBCC ...
台湾DB World的电子杂志文章,详细讲述了DBCC的使用,适合DBA管理者,(2/4)
Sybase ASE 15.7 开发文档:快速参考指南 数据类型 标准和遵从性 数据类型和加密列 Adaptive Server 的全局变量 保留字 函数 命令 交互式 dbsql 命令 系统过程 目录存储过程 扩展存储过程 dbcc 存储过程 系统表 DBCC...
dbcc输出结果,可以查询得到