In addition to the standard system tables included in all databases, the
dbcc management database, dbccdb, contains seven tables
that define inputs to and outputs from dbcc checkstorage. It also contains
at least two workspaces.
dbccdb Workspaces
Workspaces are special tables in dbccdb that store intermediate results of the dbcc checkstorage operation.
dbccdb Log
The results of each dbcc checkstorage operation are recorded in the dbccdb log. Updates to the text and scan workspaces are not recorded there.
dbcc_config
The dbcc_config table describes the currently executing or last completed dbcc checkstorage operation.
dbcc_counters
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.
dbcc_exclusions
The dbcc_exclusions table stores the faults, tables or a combination of them that should be excluded from processing by checkverify and fault reporting via sp_dbcc_faultreport.
dbcc_fault_params
The dbcc_fault_params table provides additional descriptive information for a fault entered in the dbcc_faults table.
dbcc_faults
The dbcc_faults table provides a description of each fault detected by dbcc checkstorage.
dbcc_operation_log
The dbcc_operation_log table records the use of the dbcc checkstorage operations.
dbcc_operation_results
The dbcc_operation_results table provides additional descriptive information for an operation recorded in the dbcc_operation_log table.
dbcc_types
Provides the definitions of the datatypes used by dbcc checkstorage.
Created May 28, 2014. Send feedback on this help topic to Technical Publications:
pubs@sap.com