Reevaluating and Updating the dbccdb Configuration

If the characteristics of user databases change, use sp_dbcc_evaluatedb to reevaluate the current dbccdb configuration and recommend more suitable values.

The following changes to user databases might affect the dbccdb configuration, as follows:

If the results of dbcc checkstorage operations are available for the target database, use sp_dbcc_evaluatedb to determine new configuration values. sp_dbcc_configreport also reports the configuration parameters for the specified database.

Use sp_dbcc_updateconfig to add new databases to the dbcc_config table and to change the configuration values in dbcc_config to reflect the values recommended by sp_dbcc_evaluatedb.