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.
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 |
int |
Identifies the defined object-page affinity. The value is derived from sysindexes and syspartitions. |
devid |
int |
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 null |
Matches the appropriate type_name for the given type_code as described in dbcc_types. |
Combination of dbid, id, indid, partitionid, devid, opid, and type_code
