Checking Page Allocation

The dbcc commands that you use to check page allocation are dbcc checkalloc, dbcc indexalloc, dbcc tablealloc, and dbcc textalloc.

• dbcc checkalloc
  If you do not provide a database name, dbcc checkalloc checks the current database.
• dbcc indexalloc
  dbcc indexalloc is an index-level version of dbcc checkalloc, providing the same integrity checks on an individual index, including checking for index partitions.
• dbcc tablealloc
  dbcc tablealloc requires that you specify the table name, the data partition ID, or the table’s object ID from the ID column in sysobjects.
• dbcc textalloc
  dbcc textalloc checks the allocation integrity of an object’s text and image data, and reports and fixes any problems it finds.