dbcc_系统管理员

dbcc_数据库_02

 

dbcc traceon(3640)

dbcc page(<db_id>,<file_Id>,<page_id>,<format_id>)

 

 

dbcc traceon(3640)

dbcc page(1,1,1,3)



PAGE: (1:1)


BUFFER:


BUF @0x0000000080FB29C0

bpage = 0x000000008031A000 bhash = 0x0000000000000000 bpageno = (1:1)
bdbid = 1 breferences = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 2641 bstat = 0xc0010b
blog = 0x32159 bnext = 0x0000000000000000

PAGE HEADER:


Page @0x000000008031A000

m_pageId = (1:1) m_headerVersion = 1 m_type = 11
m_typeFlagBits = 0x2 m_level = 0 m_flagBits = 0x0
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 = (192:56:10) m_xactReserved = 0
m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = -1223848106

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 @0x000000000B04C000

(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 IAM Page Mixed Ext
(1:9) - (1:10) = ALLOCATED 100_PCT_FULL Mixed Ext
(1:11) - (1:12) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:13) - = ALLOCATED 100_PCT_FULL IAM Page Mixed Ext
(1:14) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:15) - (1:16) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:17) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:18) - (1:22) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:23) - = ALLOCATED 0_PCT_FULL IAM Page 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) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:37) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:38) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:39) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:40) - (1:41) = NOT ALLOCATED 100_PCT_FULL
(1:42) - = NOT ALLOCATED 80_PCT_FULL
(1:43) - (1:44) = NOT ALLOCATED 100_PCT_FULL
(1:45) - = NOT ALLOCATED 50_PCT_FULL
(1:46) - = NOT ALLOCATED 100_PCT_FULL
(1:47) - = NOT ALLOCATED 95_PCT_FULL
(1:48) - (1:60) = ALLOCATED 0_PCT_FULL
(1:61) - (1:63) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:64) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:65) - (1:68) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:69) - (1:70) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:71) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:72) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:73) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:74) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:75) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:76) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:77) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:78) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:79) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:80) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:81) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:82) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:83) - (1:87) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:88) - (1:96) = ALLOCATED 0_PCT_FULL
(1:97) - (1:99) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:100) - = ALLOCATED 0_PCT_FULL
(1:101) - (1:102) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:103) - = NOT ALLOCATED 0_PCT_FULL
(1:104) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:105) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:106) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:107) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:108) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:109) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:110) - (1:111) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:112) - = ALLOCATED 0_PCT_FULL
(1:113) - (1:119) = NOT ALLOCATED 0_PCT_FULL
(1:120) - (1:122) = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:123) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:124) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:125) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:126) - (1:127) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:128) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:129) - = ALLOCATED 0_PCT_FULL
(1:130) - (1:159) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:160) - (1:161) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:162) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:163) - (1:164) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:165) - (1:167) = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:168) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:169) - = ALLOCATED 50_PCT_FULL Mixed Ext
(1:170) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:171) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:172) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:173) - = ALLOCATED 80_PCT_FULL Mixed Ext
(1:174) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:175) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(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) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:181) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:182) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:183) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:184) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:185) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:186) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:187) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:188) - (1:190) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:191) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:192) - (1:193) = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:194) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:195) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:196) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:197) - = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:198) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:199) - (1:200) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:201) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:202) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:203) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:204) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:205) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:206) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:207) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:208) - (1:211) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:212) - (1:214) = ALLOCATED 0_PCT_FULL
(1:215) - (1:222) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:223) - = ALLOCATED 0_PCT_FULL
(1:224) - (1:239) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:240) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:241) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:242) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:243) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:244) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:245) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:246) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:247) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:248) - (1:266) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:267) - (1:271) = ALLOCATED 0_PCT_FULL
(1:272) - (1:274) = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:275) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:276) - = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:277) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:278) - (1:283) = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:284) - (1:285) = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:286) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:287) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:288) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:289) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:290) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:291) - (1:292) = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:293) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:294) - (1:295) = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:296) - (1:300) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:301) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:302) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:303) - (1:310) = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:311) - (1:312) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:313) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:314) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:315) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:316) - (1:317) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:318) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:319) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:320) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:321) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:322) - (1:326) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:327) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:328) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:329) - (1:331) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:332) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:333) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:334) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:335) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:336) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:337) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:338) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:339) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:340) - (1:347) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:348) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:349) - (1:351) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:352) - (1:353) = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:354) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:355) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:356) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:357) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:358) - (1:360) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:361) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:362) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:363) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:364) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:365) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:366) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:367) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:368) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:369) - (1:370) = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:371) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:372) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:373) - = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:374) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:375) - (1:377) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:378) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:379) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:380) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:381) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:382) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:383) - (1:386) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:387) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:388) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:389) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:390) - (1:392) = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:393) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:394) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:395) - (1:399) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:400) - (1:407) = ALLOCATED 0_PCT_FULL
(1:408) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:409) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:410) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:411) - = NOT 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 0_PCT_FULL Mixed Ext
(1:415) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:416) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:417) - (1:423) = ALLOCATED 0_PCT_FULL
(1:424) - (1:431) = NOT ALLOCATED 0_PCT_FULL
(1:432) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:433) - (1:438) = NOT ALLOCATED 0_PCT_FULL
(1:439) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:440) - = NOT ALLOCATED 0_PCT_FULL
(1:441) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:442) - = NOT ALLOCATED 0_PCT_FULL
(1:443) - (1:447) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:448) - (1:452) = ALLOCATED 0_PCT_FULL
(1:453) - (1:463) = NOT ALLOCATED 0_PCT_FULL
(1:464) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:465) - = NOT ALLOCATED 0_PCT_FULL Has Ghost Mixed Ext
(1:466) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:467) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:468) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:469) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:470) - = ALLOCATED 50_PCT_FULL Mixed Ext
(1:471) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:472) - (1:475) = ALLOCATED 0_PCT_FULL Mixed Ext
(1:476) - = ALLOCATED 100_PCT_FULL Mixed Ext
(1:477) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:478) - = ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:479) - = ALLOCATED 0_PCT_FULL Mixed Ext
(1:480) - (1:487) = NOT ALLOCATED 0_PCT_FULL
(1:488) - (1:493) = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:494) - (1:495) = NOT ALLOCATED 0_PCT_FULL
(1:496) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:497) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:498) - = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:499) - = NOT ALLOCATED 0_PCT_FULL IAM Page Mixed Ext
(1:500) - (1:503) = NOT ALLOCATED 0_PCT_FULL Mixed Ext
(1:504) - (1:505) = NOT ALLOCATED 0_PCT_FULL
(1:506) - = NOT ALLOCATED 0_PCT_FULL Has Ghost
(1:507) - = NOT ALLOCATED 0_PCT_FULL
(1:508) - (1:511) = NOT ALLOCATED 0_PCT_FULL Has Ghost


DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
DBCC SHOWCONTIG



DBCC SHOWCONTIG 正在扫描 'spt_fallback_db' 表...
表: 'spt_fallback_db' (117575457);索引 ID: 0,数据库 ID: 1
已执行 TABLE 级别的扫描。
- 扫描页数................................: 0
- 扫描区数..............................: 0
- 区切换次数..............................: 0
- 每个区的平均页数........................: 0.0
- 扫描密度 [最佳计数:实际计数].......: 100.00% [0:0]
- 区扫描碎片 ..................: 0.00%
- 每页的平均可用字节数.....................: 0.0
- 平均页密度(满).....................: 0.00%
DBCC SHOWCONTIG 正在扫描 'spt_fallback_dev' 表...
表: 'spt_fallback_dev' (133575514);索引 ID: 0,数据库 ID: 1
已执行 TABLE 级别的扫描。
- 扫描页数................................: 0
- 扫描区数..............................: 0
- 区切换次数..............................: 0
- 每个区的平均页数........................: 0.0
- 扫描密度 [最佳计数:实际计数].......: 100.00% [0:0]
- 区扫描碎片 ..................: 0.00%
- 每页的平均可用字节数.....................: 0.0
- 平均页密度(满).....................: 0.00%
DBCC SHOWCONTIG 正在扫描 'spt_fallback_usg' 表...
表: 'spt_fallback_usg' (149575571);索引 ID: 0,数据库 ID: 1
已执行 TABLE 级别的扫描。
- 扫描页数................................: 0
- 扫描区数..............................: 0
- 区切换次数..............................: 0
- 每个区的平均页数........................: 0.0
- 扫描密度 [最佳计数:实际计数].......: 100.00% [0:0]
- 区扫描碎片 ..................: 0.00%
- 每页的平均可用字节数.....................: 0.0
- 平均页密度(满).....................: 0.00%
DBCC SHOWCONTIG 正在扫描 'spt_monitor' 表...
表: 'spt_monitor' (1115151018);索引 ID: 0,数据库 ID: 1
已执行 TABLE 级别的扫描。
- 扫描页数................................: 1
- 扫描区数..............................: 1
- 区切换次数..............................: 0
- 每个区的平均页数........................: 1.0
- 扫描密度 [最佳计数:实际计数].......: 100.00% [1:1]
- 区扫描碎片 ..................: 0.00%
- 每页的平均可用字节数.....................: 8024.0
- 平均页密度(满).....................: 0.86%
DBCC SHOWCONTIG 正在扫描 'spt_values' 表...
表: 'spt_values' (1131151075);索引 ID: 1,数据库 ID: 1
已执行 TABLE 级别的扫描。
- 扫描页数................................: 12
- 扫描区数..............................: 3
- 区切换次数..............................: 2
- 每个区的平均页数........................: 4.0
- 扫描密度 [最佳计数:实际计数].......: 66.67% [2:3]
- 逻辑扫描碎片 ..................: 25.00%
- 区扫描碎片 ..................: 33.33%
- 每页的平均可用字节数.....................: 534.3
- 平均页密度(满).....................: 93.40%
DBCC SHOWCONTIG 正在扫描 'MSreplication_options' 表...
表: 'MSreplication_options' (1163151189);索引 ID: 0,数据库 ID: 1
已执行 TABLE 级别的扫描。
- 扫描页数................................: 1
- 扫描区数..............................: 1
- 区切换次数..............................: 0
- 每个区的平均页数........................: 1.0
- 扫描密度 [最佳计数:实际计数].......: 100.00% [1:1]
- 区扫描碎片 ..................: 0.00%
- 每页的平均可用字节数.....................: 7900.0
- 平均页密度(满).....................: 2.40%
DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。


 

dbcc extentinfo: