dbcc checkalloc输出日志

donniejeck

DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
Checking WDZX: Logical pagesize is 2048 bytes
Database 'WDZX' is not in single user mode - may find spurious allocation
problems due to transactions in progress.
***************************************************************
TABLE: sysobjects                OBJID = 1
INDID=1         FIRST=49         ROOT=3512         SORT=1
        Data level: 1.  47 Data pages allocated and 7 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
INDID=2         FIRST=4800         ROOT=4802         SORT=1
        Indid          : 2.  14 Index pages allocated and 3 Extents allocated.
TOTAL # of extents = 12
***************************************************************
TABLE: sysindexes                OBJID = 2
INDID=1         FIRST=24         ROOT=32         SORT=0
        Data level: 1.  62 Data pages allocated and 9 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 10
***************************************************************
TABLE: syscolumns                OBJID = 3
INDID=1         FIRST=5420793         ROOT=5420872         SORT=1
        Data level: 1.  123 Data pages allocated and 16 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 18
***************************************************************
TABLE: systypes                OBJID = 4
INDID=1         FIRST=169         ROOT=576         SORT=1
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
INDID=2         FIRST=592         ROOT=592         SORT=1
        Indid          : 2.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 5
***************************************************************
TABLE: sysprocedures                OBJID = 5
INDID=1         FIRST=65         ROOT=5423290         SORT=1
        Data level: 1.  1649 Data pages allocated and 241 Extents allocated.
        Indid          : 1.  29 Index pages allocated and 4 Extents allocated.
TOTAL # of extents = 245
***************************************************************
TABLE: syscomments                OBJID = 6
INDID=1         FIRST=2         ROOT=5224         SORT=1
        Data level: 1.  97 Data pages allocated and 13 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 15
***************************************************************
TABLE: syssegments                OBJID = 7
INDID=0         FIRST=120         ROOT=120         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
***************************************************************
TABLE: syslogs                OBJID = 8
INDID=0         FIRST=16829804         ROOT=16830610         SORT=0
        Data level: 0.  941 Data pages allocated and 118 Extents allocated.
TOTAL # of extents = 118
***************************************************************
TABLE: sysprotects                OBJID = 9
INDID=1         FIRST=113         ROOT=5240         SORT=0
        Data level: 1.  2 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysusers                OBJID = 10
INDID=1         FIRST=161         ROOT=184         SORT=0
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
INDID=2         FIRST=632         ROOT=632         SORT=0
        Indid          : 2.  1 Index pages allocated and 2 Extents allocated.
INDID=3         FIRST=5968         ROOT=5968         SORT=0
        Indid          : 3.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 7
***************************************************************
TABLE: sysalternates                OBJID = 11
INDID=1         FIRST=41         ROOT=320         SORT=1
        Data level: 1.  9 Data pages allocated and 2 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 4
***************************************************************
TABLE: sysdepends                OBJID = 12
INDID=1         FIRST=216         ROOT=224         SORT=0
        Data level: 1.  10 Data pages allocated and 3 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 4
***************************************************************
TABLE: syskeys                OBJID = 13
INDID=1         FIRST=193         ROOT=5288         SORT=1
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysusermessages                OBJID = 15
INDID=1         FIRST=233         ROOT=241         SORT=0
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
INDID=2         FIRST=5385         ROOT=5385         SORT=0
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysreferences                OBJID = 16
INDID=1         FIRST=129         ROOT=209         SORT=0
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
INDID=2         FIRST=249         ROOT=249         SORT=0
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
INDID=3         FIRST=5521         ROOT=5521         SORT=0
        Indid          : 3.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 4
***************************************************************
TABLE: sysconstraints                OBJID = 17
INDID=1         FIRST=105         ROOT=145         SORT=0
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
INDID=2         FIRST=258         ROOT=258         SORT=0
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: systhresholds                OBJID = 18
INDID=1         FIRST=273         ROOT=296         SORT=0
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysroles                OBJID = 19
INDID=1         FIRST=305         ROOT=328         SORT=0
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 3
***************************************************************
TABLE: sysattributes                OBJID = 21
INDID=1         FIRST=385         ROOT=369         SORT=1
        Data level: 1.  8 Data pages allocated and 2 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
INDID=2         FIRST=346         ROOT=345         SORT=1
        Indid          : 2.  3 Index pages allocated and 1 Extents allocated.
INDID=255         FIRST=289         ROOT=289         SORT=0
TOTAL # of extents = 4
***************************************************************
TABLE: syspartitions                OBJID = 22
INDID=1         FIRST=417         ROOT=409         SORT=1
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: systabstats                OBJID = 23
INDID=0         FIRST=392         ROOT=392         SORT=1
        Data level: 0.  48 Data pages allocated and 8 Extents allocated.
INDID=2         FIRST=433         ROOT=432         SORT=1
        Indid          : 2.  8 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 1
#Leaf pages =  7
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1904
Leaf pages 3784
#undeleted rids (leaf pages) =  562
TOTAL # of extents = 10
***************************************************************
TABLE: sysstatistics                OBJID = 24
INDID=0         FIRST=441         ROOT=441         SORT=0
        Data level: 0.  177 Data pages allocated and 25 Extents allocated.
INDID=2         FIRST=457         ROOT=456         SORT=1
        Indid          : 2.  49 Index pages allocated and 8 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 1
#Leaf pages =  48
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1154
Leaf pages 35352
#undeleted rids (leaf pages) =  2690
TOTAL # of extents = 33
***************************************************************
TABLE: sysxtypes                OBJID = 25
INDID=0         FIRST=473         ROOT=473         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=497         ROOT=496         SORT=1
        Indid          : 2.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1986
Leaf pages 2002
#undeleted rids (leaf pages) =  0
INDID=3         FIRST=521         ROOT=520         SORT=1
        Indid          : 3.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 3
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1986
Leaf pages 2002
#undeleted rids (leaf pages) =  0
INDID=255         FIRST=465         ROOT=465         SORT=0
TOTAL # of extents = 5
***************************************************************
TABLE: sysjars                OBJID = 26
INDID=0         FIRST=529         ROOT=529         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=545         ROOT=544         SORT=1
        Indid          : 2.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1986
Leaf pages 2002
#undeleted rids (leaf pages) =  0
INDID=3         FIRST=561         ROOT=560         SORT=1
        Indid          : 3.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 3
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1986
Leaf pages 2002
#undeleted rids (leaf pages) =  0
INDID=255         FIRST=489         ROOT=489         SORT=0
TOTAL # of extents = 5
***************************************************************
TABLE: sysqueryplans                OBJID = 27
INDID=0         FIRST=337         ROOT=337         SORT=1
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=361         ROOT=360         SORT=0
        Indid          : 2.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1938
Leaf pages 2002
#undeleted rids (leaf pages) =  0
INDID=3         FIRST=5793         ROOT=5792         SORT=0
        Indid          : 3.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 3
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1962
Leaf pages 2002
#undeleted rids (leaf pages) =  0
TOTAL # of extents = 5
***************************************************************
TABLE: SYSTEMUSERS                OBJID = 9051068
INDID=0         FIRST=3185         ROOT=3185         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=3193         ROOT=3193         SORT=1
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: TPTG                OBJID = 16003088
INDID=0         FIRST=625         ROOT=625         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=641         ROOT=641         SORT=1
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: DAWS2AJ                OBJID = 21575115
INDID=0         FIRST=4505         ROOT=4506         SORT=0
        Data level: 0.  2 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=4514         ROOT=4513         SORT=1
        Indid          : 2.  3 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: S_EXDATA                OBJID = 27147142
INDID=1         FIRST=1921369         ROOT=1921361         SORT=1
        Data level: 1.  1258 Data pages allocated and 158 Extents allocated.
        Indid          : 1.  13 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 160
***************************************************************
TABLE: G_UACTS                OBJID = 28527135
INDID=0         FIRST=5033         ROOT=159724         SORT=1
        Data level: 0.  209 Data pages allocated and 28 Extents allocated.
INDID=2         FIRST=161401         ROOT=161400         SORT=0
        Indid          : 2.  292 Index pages allocated and 39 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 2
#Leaf pages =  288
#Nonleaf pages =  4
Total free space in bytes:
Nonleaf pages 3719
Leaf pages 205432
#undeleted rids (leaf pages) =  20664
TOTAL # of extents = 67
***************************************************************
TABLE: SYSTEMSUPERVISOR                OBJID = 41051182
INDID=0         FIRST=3201         ROOT=3201         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=3209         ROOT=3209         SORT=1
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: QB                OBJID = 48003202
INDID=0         FIRST=657         ROOT=15500827         SORT=0
        Data level: 0.  113 Data pages allocated and 15 Extents allocated.
INDID=2         FIRST=666         ROOT=665         SORT=1
        Indid          : 2.  38 Index pages allocated and 5 Extents allocated.
INDID=255         FIRST=649         ROOT=649         SORT=0
TOTAL # of extents = 20
***************************************************************
TABLE: DAWS2WJ                OBJID = 53575229
INDID=0         FIRST=4529         ROOT=14822720         SORT=0
        Data level: 0.  16 Data pages allocated and 3 Extents allocated.
INDID=2         FIRST=4538         ROOT=4537         SORT=1
        Indid          : 2.  31 Index pages allocated and 4 Extents allocated.
INDID=255         FIRST=4521         ROOT=4521         SORT=0
TOTAL # of extents = 7
***************************************************************
TABLE: G_PROUTE                OBJID = 60527249
INDID=0         FIRST=2017         ROOT=1037986         SORT=1
        Data level: 0.  19545 Data pages allocated and 2715 Extents allocated.
INDID=2         FIRST=2006657         ROOT=2006656         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=14093081;  page# pointing to this page=14093067; previous page#
indicated in this page=14093555)
Msg 2502, Level 16, State 1:
Server 'CQ', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page:page
number=14093081  allocation status=247
TOTAL # of extents = 2715
***************************************************************
TABLE: SYSTEMOPTIONS                OBJID = 73051296
INDID=0         FIRST=3225         ROOT=15481841         SORT=0
        Data level: 0.  81 Data pages allocated and 11 Extents allocated.
INDID=2         FIRST=1688657         ROOT=1688656         SORT=1
        Indid          : 2.  110 Index pages allocated and 14 Extents allocated.
INDID=255         FIRST=3217         ROOT=3217         SORT=0
TOTAL # of extents = 25
***************************************************************
TABLE: S_EXINBOX                OBJID = 75147313
INDID=1         FIRST=1921393         ROOT=1921385         SORT=1
        Data level: 1.  293 Data pages allocated and 38 Extents allocated.
        Indid          : 1.  3 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 39
***************************************************************
TABLE: AGENDA                OBJID = 80003316
INDID=0         FIRST=673         ROOT=10766496         SORT=0
        Data level: 0.  16 Data pages allocated and 3 Extents allocated.
INDID=2         FIRST=682         ROOT=681         SORT=1
        Indid          : 2.  4 Index pages allocated and 1 Extents allocated.
INDID=3         FIRST=690         ROOT=689         SORT=1
        Indid          : 3.  8 Index pages allocated and 2 Extents allocated.
INDID=4         FIRST=698         ROOT=697         SORT=1
        Indid          : 4.  8 Index pages allocated and 2 Extents allocated.
TOTAL # of extents = 8
***************************************************************
TABLE: FR_BBFA                OBJID = 85575343
INDID=0         FIRST=4545         ROOT=4545         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=4553         ROOT=4553         SORT=1
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: G_PPRIVILEGE                OBJID = 92527363
INDID=0         FIRST=4593         ROOT=4593         SORT=1
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=65545         ROOT=65544         SORT=0
        Indid          : 2.  2 Index pages allocated and 2 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 1
#Leaf pages =  1
#Nonleaf pages =  1
Total free space in bytes:
Nonleaf pages 1982
Leaf pages 2002
#undeleted rids (leaf pages) =  0
TOTAL # of extents = 3
***************************************************************
TABLE: S_EXOUTBOX                OBJID = 107147427
INDID=1         FIRST=1921409         ROOT=1921401         SORT=1
        Data level: 1.  253 Data pages allocated and 32 Extents allocated.
        Indid          : 1.  3 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 33
***************************************************************
TABLE: FR_FATJ                OBJID = 117575457
INDID=1         FIRST=4577         ROOT=4569         SORT=1
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: G_PNODES                OBJID = 124527477
INDID=0         FIRST=2065         ROOT=5756479         SORT=1
Msg 7949, Level 18, State 1:
Server 'CQ', Line 1:
The number of pages used and unused for object 124527477 index 0 on allocation
page 13969408 do not match the counts in the OAM entry.
Msg 7940, Level 18, State 1:
Server 'CQ', Line 1:
The counts in the OAM are incorrect.  This implies that there are entries
missing.  Run tablealloc utility with the FIX option on the table with the
inaccurate OAM counts.
        Data level: 0.  84321 Data pages allocated and 11246 Extents allocated.
INDID=2         FIRST=6383401         ROOT=6383400         SORT=0
        Indid          : 2.  21331 Index pages allocated and 3795 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 3
#Leaf pages =  20800
#Nonleaf pages =  531
Total free space in bytes:
Nonleaf pages 737234
Leaf pages 12433990
#undeleted rids (leaf pages) =  32705
INDID=3         FIRST=6455985         ROOT=6455984         SORT=0
        Indid          : 3.  7189 Index pages allocated and 1036 Extents allocated.

Index Statistics for INDID 3
#Levels in index = 2
#Leaf pages =  7136
#Nonleaf pages =  53
Total free space in bytes:
Nonleaf pages 28600
Leaf pages 5693408
#undeleted rids (leaf pages) =  32705
TOTAL # of extents = 16077
***************************************************************
TABLE: SYSAUDIT                OBJID = 137051524
INDID=0         FIRST=3249         ROOT=6865234         SORT=0
        Data level: 0.  265 Data pages allocated and 34 Extents allocated.
INDID=2         FIRST=3258         ROOT=3257         SORT=1
        Indid          : 2.  132 Index pages allocated and 18 Extents allocated.
INDID=3         FIRST=3266         ROOT=3265         SORT=1
        Indid          : 3.  142 Index pages allocated and 25 Extents allocated.
INDID=4         FIRST=3274         ROOT=3273         SORT=1
        Indid          : 4.  124 Index pages allocated and 21 Extents allocated.
INDID=5         FIRST=3282         ROOT=3281         SORT=1
        Indid          : 5.  222 Index pages allocated and 29 Extents allocated.
INDID=255         FIRST=3241         ROOT=3241         SORT=0
TOTAL # of extents = 127
***************************************************************
TABLE: FR_TJYS                OBJID = 149575571
INDID=0         FIRST=4561         ROOT=4561         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=4585         ROOT=4585         SORT=1
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: EditorInfo                OBJID = 155147598
INDID=1         FIRST=4841         ROOT=4833         SORT=1
        Data level: 1.  1 Data pages allocated and 1 Extents allocated.
        Indid          : 1.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2
***************************************************************
TABLE: USER_FLOWTEMPLATE                OBJID = 169051638
INDID=0         FIRST=3289         ROOT=3289         SORT=0
        Data level: 0.  1 Data pages allocated and 1 Extents allocated.
INDID=2         FIRST=3297         ROOT=3297         SORT=1
        Indid          : 2.  1 Index pages allocated and 1 Extents allocated.
TOTAL # of extents = 2

donniejeck

***************************************************************
TABLE: G_PROUTE                OBJID = 60527249
INDID=0         FIRST=2017         ROOT=1037986         SORT=1
        Data level: 0.  19545 Data pages allocated and 2715 Extents allocated.
INDID=2         FIRST=2006657         ROOT=2006656         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=14093081;  page# pointing to this page=14093067; previous page#
indicated in this page=14093555)
Msg 2502, Level 16, State 1:
Server 'CQ', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page:page
number=14093081  allocation status=247
TOTAL # of extents = 2715
***************************************************************
TABLE: G_PNODES                OBJID = 124527477
INDID=0         FIRST=2065         ROOT=5756479         SORT=1
Msg 7949, Level 18, State 1:
Server 'CQ', Line 1:
The number of pages used and unused for object 124527477 index 0 on allocation
page 13969408 do not match the counts in the OAM entry.
Msg 7940, Level 18, State 1:
Server 'CQ', Line 1:
The counts in the OAM are incorrect.  This implies that there are entries
missing.  Run tablealloc utility with the FIX option on the table with the
inaccurate OAM counts.
        Data level: 0.  84321 Data pages allocated and 11246 Extents allocated.
INDID=2         FIRST=6383401         ROOT=6383400         SORT=0
        Indid          : 2.  21331 Index pages allocated and 3795 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 3
#Leaf pages =  20800
#Nonleaf pages =  531
Total free space in bytes:
Nonleaf pages 737234
Leaf pages 12433990
#undeleted rids (leaf pages) =  32705
INDID=3         FIRST=6455985         ROOT=6455984         SORT=0
        Indid          : 3.  7189 Index pages allocated and 1036 Extents allocated.

Index Statistics for INDID 3
#Levels in index = 2
#Leaf pages =  7136
#Nonleaf pages =  53
Total free space in bytes:
Nonleaf pages 28600
Leaf pages 5693408
#undeleted rids (leaf pages) =  32705
TOTAL # of extents = 16077
***************************************************************
TABLE: G_VIEWFILES                OBJID = 341576255
INDID=0         FIRST=2265         ROOT=589295         SORT=1
Msg 7949, Level 18, State 1:
Server 'CQ', Line 1:
The number of pages used and unused for object 341576255 index 0 on allocation
page 13533696 do not match the counts in the OAM entry.
Msg 7940, Level 18, State 1:
Server 'CQ', Line 1:
The counts in the OAM are incorrect.  This implies that there are entries
missing.  Run tablealloc utility with the FIX option on the table with the
inaccurate OAM counts.
        Data level: 0.  1589 Data pages allocated and 211 Extents allocated.
INDID=2         FIRST=633025         ROOT=633024         SORT=0
        Indid          : 2.  510 Index pages allocated and 68 Extents allocated.

Index Statistics for INDID 2
#Levels in index = 2
#Leaf pages =  503
#Nonleaf pages =  7
Total free space in bytes:
Nonleaf pages 5559
Leaf pages 294373
#undeleted rids (leaf pages) =  37497
INDID=255         FIRST=4633         ROOT=4633         SORT=0
TOTAL # of extents = 279
***************************************************************
TABLE: G_UFILES                OBJID = 876530156
INDID=0         FIRST=1985         ROOT=2252528         SORT=1
Msg 7949, Level 18, State 1:
Server 'CQ', Line 1:
The number of pages used and unused for object 876530156 index 0 on allocation
page 17462016 do not match the counts in the OAM entry.
Msg 7940, Level 18, State 1:
Server 'CQ', Line 1:
The counts in the OAM are incorrect.  This implies that there are entries
missing.  Run tablealloc utility with the FIX option on the table with the
inaccurate OAM counts.
        Data level: 0.  35712 Data pages allocated and 4556 Extents allocated.
INDID=2         FIRST=4086129         ROOT=4086128         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=17462044;  page# pointing to this page=17371874; previous page#
indicated in this page=17461989)
            Page linkage traversed with BAD PREV pointers for OBJID 876530156
INDID 2, processed 39761 pages
TOTAL # of extents = 4556
***************************************************************
TABLE: G_INFOS                OBJID = 1099150961
INDID=0         FIRST=1897         ROOT=15574764         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=15574765;  page# pointing to this page=15574765; previous page#
indicated in this page=15574766)
Msg 2502, Level 16, State 1:
Server 'CQ', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page:page
number=15574765  allocation status=255
            Page linkage failed for OBJID 1099150961 INDID 0; Processed 13328
pages;
INDID=2         FIRST=1930         ROOT=1929         SORT=1
        Indid          : 2.  2673 Index pages allocated and 348 Extents allocated.
INDID=3         FIRST=1946         ROOT=1945         SORT=1
        Indid          : 3.  3788 Index pages allocated and 509 Extents allocated.
INDID=4         FIRST=1954         ROOT=1953         SORT=1
        Indid          : 4.  3680 Index pages allocated and 496 Extents allocated.
INDID=5         FIRST=2042         ROOT=2041         SORT=1
        Indid          : 5.  764 Index pages allocated and 101 Extents allocated.
INDID=6         FIRST=2090         ROOT=2089         SORT=1
        Indid          : 6.  1721 Index pages allocated and 228 Extents allocated.
INDID=7         FIRST=2130         ROOT=2129         SORT=1
        Indid          : 7.  1883 Index pages allocated and 252 Extents allocated.
INDID=8         FIRST=2290         ROOT=2289         SORT=1
        Indid          : 8.  802 Index pages allocated and 116 Extents allocated.
INDID=9         FIRST=2458         ROOT=2457         SORT=1
        Indid          : 9.  3270 Index pages allocated and 434 Extents allocated.
INDID=10         FIRST=2738         ROOT=2737         SORT=1
        Indid          : 10.  767 Index pages allocated and 105 Extents allocated.
INDID=11         FIRST=2962         ROOT=2961         SORT=1
        Indid          : 11.  1597 Index pages allocated and 216 Extents allocated.
INDID=12         FIRST=3130         ROOT=3129         SORT=1
        Indid          : 12.  1616 Index pages allocated and 222 Extents allocated.
INDID=13         FIRST=4602         ROOT=4601         SORT=1
        Indid          : 13.  1002 Index pages allocated and 146 Extents allocated.
TOTAL # of extents = 3173
***************************************************************
TABLE: LONGTEXT                OBJID = 1628532835
INDID=0         FIRST=2873         ROOT=17678742         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=17678743;  page# pointing to this page=17678743; previous page#
indicated in this page=17678816)
Msg 2502, Level 16, State 1:
Server 'CQ', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page:page
number=17678743  allocation status=255
            Page linkage failed for OBJID 1628532835 INDID 0; Processed 50149
pages;
INDID=2         FIRST=2882         ROOT=2881         SORT=1
        Indid          : 2.  40529 Index pages allocated and 5191 Extents allocated.
INDID=255         FIRST=2865         ROOT=2865         SORT=0
TOTAL # of extents = 5191
***************************************************************
TABLE: G_INBOX                OBJID = 2128010612
INDID=0         FIRST=195657         ROOT=339044         SORT=1
        Data level: 0.  3543 Data pages allocated and 474 Extents allocated.
INDID=2         FIRST=343105         ROOT=343104         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=14848344;  page# pointing to this page=14169843; previous page#
indicated in this page=14598083)
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=14848345;  page# pointing to this page=14848344; previous page#
indicated in this page=14598083)
Msg 2502, Level 16, State 1:
Server 'CQ', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page:page
number=14848345  allocation status=255
INDID=3         FIRST=371233         ROOT=371232         SORT=0
Msg 7949, Level 18, State 1:
Server 'CQ', Line 1:
The number of pages used and unused for object 2128010612 index 3 on allocation
page 14088192 do not match the counts in the OAM entry.
Msg 7940, Level 18, State 1:
Server 'CQ', Line 1:
The counts in the OAM are incorrect.  This implies that there are entries
missing.  Run tablealloc utility with the FIX option on the table with the
inaccurate OAM counts.
        Indid          : 3.  3275 Index pages allocated and 539 Extents allocated.

Index Statistics for INDID 3
#Levels in index = 3
#Leaf pages =  3106
#Nonleaf pages =  169
Total free space in bytes:
Nonleaf pages 285536
Leaf pages 2432987
#undeleted rids (leaf pages) =  26102
INDID=4         FIRST=371561         ROOT=371560         SORT=0
        Indid          : 4.  840 Index pages allocated and 195 Extents allocated.

Index Statistics for INDID 4
#Levels in index = 2
#Leaf pages =  794
#Nonleaf pages =  46
Total free space in bytes:
Nonleaf pages 83824
Leaf pages 495772
#undeleted rids (leaf pages) =  26209
INDID=5         FIRST=399657         ROOT=399656         SORT=0
        Indid          : 5.  333 Index pages allocated and 55 Extents allocated.

Index Statistics for INDID 5
#Levels in index = 2
#Leaf pages =  328
#Nonleaf pages =  5
Total free space in bytes:
Nonleaf pages 4182
Leaf pages 228944
#undeleted rids (leaf pages) =  26157
INDID=6         FIRST=401561         ROOT=401560         SORT=0
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=14126478;  page# pointing to this page=14143448; previous page#
indicated in this page=14138054)
Msg 2503, Level 16, State 2:
Server 'CQ', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=14126587;  page# pointing to this page=14126478; previous page#
indicated in this page=14144846)
Msg 2502, Level 16, State 1:
Server 'CQ', Line 1:
Table Corrupt: A page is linked in more than one chain; check this page:page
number=14126587  allocation status=255
INDID=7         FIRST=450313         ROOT=450312         SORT=0
        Indid          : 7.  886 Index pages allocated and 200 Extents allocated.

Index Statistics for INDID 7
#Levels in index = 2
#Leaf pages =  784
#Nonleaf pages =  102
Total free space in bytes:
Nonleaf pages 195368
Leaf pages 503580
#undeleted rids (leaf pages) =  26198
TOTAL # of extents = 1463

donniejeck

dbcc checkalloc(Dbname,fix)也修复过了，还是一样的出错

chuxu

Database 'WDZX' is not in single user mode - may find spurious allocation
problems due to transactions in progress.

这个提示很关键呀。
是否当时还是有应用在使用这个环境？

donniejeck

dbcc checkalloc(WDZX,fix)
必须得在单用户模式下