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 primary key is the combination of dbid, id, indid, partitionid, devid, opid, and type_code
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 dbcc_types. Valid values are 5000 through 5024. |
value |
real null |
Matches the appropriate type_name for the given type_code as described in dbcc_types. |