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.
Scripting and Automation for SQL Server