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:
When a user database is created, deleted or altered, the size of the workspaces and named cache, or the number of worker threads stored in the dbcc_config table might be affected.
Changes in the named cache size or worker process count for dbcc_checkstorage may require you to reconfigure buffer cache and worker processes.
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.
