dbcc_counters

Description

The dbcc_counters table stores the results of the analysis performed by dbcc checkstorage. Counters are maintained for each database, table, index, partition, device, and invocation of dbcc.


Columns

The columns for dbcc_counters are:

Column name

Datatype

Description

dbid

smallint

Identifies the target database.

id

int

Identifies the table. The value is derived from sysindexes and sysobjects.

indid

smallint

Identifies the index. The value is derived from sysindexes.

partitionid

smallint

Identifies the defined object-page affinity. The value is derived from sysindexes and syspartitions.

devid

smallint

Identifies the disk device. The value is derived from sysdevices.

opid

smallint

Identifies the dbcc operation that was performed.

type_code

int

Matches the type_code column of a row in the dbcc_types table. Valid values are 5000 through 5024.

value

real

Matches the appropriate type_name for the given type_code as described in dbcc_types.


Primary key

Combination of dbid, id, indid, partitionid, devid, opid, and type_code