dbcc checkstorage

On data-only-locked (DOL) tables, there are additional types of returned codes for dbcc checkstorage. The dbcc_types tables in the dbccdb have all the codes and definitions.

Statistic Types

Code	Definition
5020	`Deleted rows, the number of deleted rows in the object`
5021	`Forwarded rows, number of forwarded rows in the object`
5022	`The number of pages allocated but not containing data`
5023	`Pages with garbage, number of pages that could benefit from garbage collection`
5024	`Non-contiguous free space, number of bytes of non-contiguous free space`

Fault parameter types:

Code	Definitions
10010	`Data Only Locked data page header, the 44 byte page header for the page where the fault is located`
10011	`Data Only Locked btree leaf page header, the 44 byte page header for the page where the fault is located`
10012	`Data Only Locked btree page header, the 44 byte page header for the page where the fault is located`

Fault types:

Code	Definitions
100033	`Non-contiguous free space error, invalid or inconsistent value for the non-contiguous free space on the page`
100034	`Insert free space error, invalid or inconsistent value for the contiguous free space on the page`
100035	`spacebits mismatch, inconsistency in the page fullness indicator`
100036	`deleted row count error, invalid or inconsistent value for the deleted row count on the page`
100037	`Forwarded rows error, inconsistency between the forwarded rows indicator and the number of forwarded rows on the page`
100038	`Page header type error, Page header format indicator set incorrectly`