• dbcc


    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:

  • 相关阅读:
    Oracle工具的探索之旅(一)
    对ODB管理工具(EM,SQL Plus,Net Manager,Net Configuration Assistant,Administration Assistant for Windows,Database Configuration Assistant......)的简单认识
    偶然发现的VS2010的调试Watch查看也有F11的调试功能
    安装和卸载Oracle 10g数据库
    对Oracle的初步了解
    Oracle工具的探索之旅(二)
    对Oracle的初步认识
    [HDL]4/8/16/32/64位乘法器的设计(转)
    用ASP.NET WebForm的FileUpload控件上传文件
    C#图片和byte[]的互相转换
  • 原文地址:https://www.cnblogs.com/zengkefu/p/5796930.html
Copyright © 2020-2023  润新知