sp_plan_dbccdb and sp_dbcc_evaluatedb -
12-04-2003
, 11:07 AM
Hello, I am running both these stored procs for the same database, and
I am getting different values for the suggested text workspace size
and the suggested cache size(results shown below). Why am I getting
different values and which one should I trust?
Thank you,
David
Query: exec sp_plan_dbccdb production exec sp_dbcc_evaluatedb
production
Recommended size for dbccdb database is 239MB (data = 237MB, log =
2MB).
dbccdb database already exists with size 600MB.
Recommended values for workspace size, cache size and process count
are:
dbname scan ws text ws cache
process count
production 144M 36M 36M 2
Recommended values for workspace size, cache size and process count
are:
Database name : production
current scan workspace size : 145M suggested scan workspace size
: 144M
current text workspace size : 36M suggested text workspace size :
288M
current cache size : 36M suggested cache size : 70M
current process count : 2 suggested process count : 2 |