Hi ,

Am going to configure the dbccdb database in Pre-PROD server, The
database size (ABC) in in nearly 800gb, i run the following cmd,

sp_plan_dbccdb ABC

Recommended size for dbccdb database is 14525MB (data = 14523MB, log =
2MB).

No suitable devices for dbccdb in master..sysdevices.
Recommended values for workspace size, cache size and process count
are:

dbname scan ws text ws cache comp mem
process count

ABC 9673M 2419M 2419M 0K
28
(return status = 0)

Now my question what is size of buffer pool?

sp_poolconfig “dbccdb_cache", "{pool_size}M", "16K"