Recomputes configuration information for the target database and compares it to the current configuration information.
sp_dbcc_evaluatedb [dbname]
specifies the name of the target database. If dbname is not specified, sp_dbcc_evaluatedb compares all databases listed in the dbcc_config table.
Recomputes configuration information for the current database, sybsystemprocs, and suggests new values for some parameters:
sp_dbcc_evaluatedb
Recommended values for workspace size, cache size and worker process count are: Database name : sybsystemprocs current scan workspace size : 400K suggested scan workspace size : 272K current text workspace size : 208K suggested text workspace size : 208K current cache size : 1024K suggested cache size : 640K current process count : 1 suggested process count : 1
sp_dbcc_evaluatedb recomputes configuration information for the target database and compares the data to the current configuration information. It uses counter values recorded for the target database in the dbcc_counters table.
The cache size is the size of the 16K buffer pool in the cache. For a 2K buffer pool, the minimum size of this cache must be the recommended value, plus 512.
When the size and data distribution pattern of the target database changes, run sp_dbcc_evaluatedb to optimize the configuration information.
To gather configuration information for the target database the first time, use sp_plan_dbccdb.
To make sure you are evaluating the most current configuration parameters, run sp_dbcc_updateconfig before running sp_dbcc_evaluatedb.
Only System Administrator or the Database Owner can run sp_dbcc_evaluatedb.
Only a System Administrator can run sp_dbcc_evaluatedb without specifying a database name.
Commands dbcc
dbcc stored procedures sp_dbcc_updateconfig
System procedures sp_plan_dbccdb
