You occasionally need to perform maintenance tasks on dbccdb.
Reevaluate and update the configuration using:
sp_dbcc_evaluatedb – recommends values for configuration parameters using the results of previous dbcc checkstorage operations.
sp_dbcc_updateconfig – updates the configuration parameters for the specified database.
Clean up obsolete data in dbccdb:
sp_dbcc_deletedb – deletes all the information on the specified database from dbccdb.
sp_dbcc_deletehistory – deletes the results of the dbcc checkstorage operations on the specified database from dbccdb.
Remove unnecessary workspaces.
Perform consistency checks on dbccdb itself.
The following sections describe the maintenance tasks in greater detail.
