• Hi Gail,

    First off, thanks for the great article and thanks to the SSC folks for making it so easy to find.

    I've just started a new DBA job at a company and found some DBCC CHECKDB errors that fall into the second "non-serious" category you listed under Inaccurate Space Metadata.

    In my case, the table with the issue happens to be a system table,

    table 'sys.sysobjvalues' (object ID 60)

    , and I wondered if that would impact (change) the answer you gave in any way.

    Thanks,

    Doug

    DBCC output is below:

    Msg 8914, Level 16, State 1, Line 1

    Incorrect PFS free space information for page (1:75) in object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

    Msg 8914, Level 16, State 1, Line 1

    Incorrect PFS free space information for page (1:117) in object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

    CHECKDB found 0 allocation errors and 2 consistency errors in table 'sys.sysobjvalues' (object ID 60).