dbcc checkstorage stores the results in the dbccdb database. You can print a variety of reports from this database. For details, see “dbcc checkstorage”.
The output of most other dbcc commands includes information that identifies the objects being checked and error messages that indicate any problems, the command finds in the object. When you run dbcc tablealloc and dbcc indexalloc with fix, the output also indicates the repairs that the command makes.
The following example shows dbcc tablealloc output for a table with an allocation error:
dbcc tablealloc(rrtab)
The default report option of OPTIMIZED is used for this run. The default fix option of FIX is used for this run. *************************************************************** TABLE: rrtab OBJID = 416001482 PARTITION ID=432001539 FIRST=2032 ROOT=2040 SORT=1 Data level: indid 1, partition 432001539. 2 Data pages allocated and 2 Extents allocated. Indid : 1, partition : 432001539. 1 Index pages allocated and 2 Extents allocated. PARTITION ID=448001596 FIRST=2064 ROOT=2072 SORT=1 Data level: indid 1, partition 448001596. 2 Data pages allocated and 2 Extents allocated.Indid : 1, partition : 448001596. 1 Index pages allocated and 2 Extents allocated. PARTITION ID=480001710 FIRST=2080 ROOT=2080 SORT=0 Indid : 2, partition : 480001710. 1 Index pages allocated and 2 Extents allocated. PARTITION ID=496001767 FIRST=2096 ROOT=2096 SORT=0 Indid : 2, partition : 496001767. 1 Index pages allocated and 2 Extents allocated. PARTITION ID=512001824 FIRST=2112 ROOT=2112 SORT=0 Indid : 3, partition : 512001824. 1 Index pages allocated and 2 Extents allocated. PARTITION ID=528001881 FIRST=2128 ROOT=2128 SORT=0 Indid : 3, partition : 528001881. 1 Index pages allocated and 2 Extents allocated. PARTITION ID=544001938 FIRST=680 ROOT=680 SORT=0 Indid : 4, partition : 544001938. 1 Index pages allocated and 2 Extents allocated. TOTAL # of extents = 18 Alloc page 1792 (# of extent=2 used pages=2 ref pages=2) Alloc page 1792 (# of extent=2 used pages=3 ref pages=3) Alloc page 1792 (# of extent=1 used pages=1 ref pages=1) Alloc page 2048 (# of extent=1 used pages=1 ref pages=1) Alloc page 1792 (# of extent=1 used pages=1 ref pages=1) Alloc page 2048 (# of extent=1 used pages=2 ref pages=2) Alloc page 2048 (# of extent=2 used pages=3 ref pages=3) Alloc page 2048 (# of extent=2 used pages=2 ref pages=2) Alloc page 2048 (# of extent=2 used pages=2 ref pages=2) Alloc page 2048 (# of extent=2 used pages=2 ref pages=2) Alloc page 256 (# of extent=1 used pages=1 ref pages=1) Alloc page 512 (# of extent=1 used pages=1 ref pages=1) Total (# of extent=18 used pages=21 ref pages=21) in this database DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role..
