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