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 indexalloc checks the specified index to see that:

You must specify an object ID, an object name, or a partition ID, and you must also specify an index ID. dbcc checkalloc and dbcc indexalloc output includes index IDs.

To use the fix or nofix option for dbcc indexalloc, you must specify one of the report options (full, optimized, fast, or null). If you specify a partition ID, only that partition is checked.

dbcc indexalloc treats unpartitioned indexes as indexes with a single partition.

You can run sp_indsuspect to check the consistency of sort order in indexes, and dbcc reindex to repair inconsistencies.

Related concepts
Generate Reports with dbcc tablealloc and dbcc indexalloc
Related tasks
Correcting Allocation Errors Using the fix | nofix Options