sp_dbcc_evaluatedb

Description

Recomputes configuration information for the target database and compares it to the current configuration information.

Syntax

sp_dbcc_evaluatedb [dbname]

Parameters

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.

Examples

Example 1

Recomputes configuration information for the current database, sybsystemprocs, and suggests new values for some parameters:

1> sp_dbcc_evaluatedb
2> go
Recommended values for workspace size, cache size and process count are:
 
Database name : one_G
                                      current         suggested
scan workspace size :                    750M               16M
text workspace size :                      2K               48K
cache size          :                  10240K             1280K
process count       :                       3                 2
 
Each of the reported quantities is reported in a scaled unit according to
G if size > 10G
M if 10M < size <=10 G
K otherwise

Usage

Permissions

See also

Commands dbcc

dbcc stored procedures sp_dbcc_updateconfig

System procedures sp_plan_dbccdb