SQLConfiguration SQLConfiguration


Monitoring Databases  «Prev

dbcc checkalloc output

When running dbcc checkalloc, you will see an output similar to this one:
dbcc checkalloc
go
…. 

***************************************************************
Table employee                Object ID 693577509.
Index ID 1         FirstIAM (1:131)   Root (1:132)    Dpages 1     Sort 0.
    Data level 1. 3 data pages in 0 extents.
Index ID 2         FirstIAM (1:134)   Root (1:133)    Dpages 1     Sort 0.
    Index ID 2. 2 index pages in 0 extents.
Total number of extents is 0.
***************************************************************

Table a1                Object ID 965578478.
Index ID 0         FirstIAM (1:162)   Root (1:161)    Dpages 1     Sort 0.
    Data level 1. 2 data pages in 1 extents.
Total number of extents is 1.

***************************************************************

Processed 44 entries in sysindexes for database ID 5.

Allocation page (1:2). Number of extents = 22, used pages = 149, referenced pages = 100.

           (1:2) (number of mixed extents = 18, mixed pages = 134).
. . .

Object ID 645577338, Index ID 1, data extents 0, pages 3, mixed extent pages 3.

Object ID 645577338, Index ID 255, index extents 1, pages 14, mixed extent pages 9.

Object ID 693577509, Index ID 1, data extents 0, pages 3, mixed extent pages 3.

Object ID 693577509, Index ID 2, index extents 0, pages 2, mixed extent pages 2.

Object ID 965578478, Index ID 0, data extents 1, pages 2, mixed extent pages 1.

Total number of extents = 22, used pages = 149, referenced pages = 100 in this database.

(number of mixed extents = 18, mixed pages = 134) in this database.

CHECKALLOC found 0 allocation errors and 0 consistency errors in database 'pubs'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator

The output will contain a section for every table in the database, describing the space allocated to the table along with any errors. This will be followed by a one-line report for each table.