dbTalk Databases Forums  

sp_plan_dbccdb and sp_dbcc_evaluatedb

comp.databases.sybase comp.databases.sybase


Discuss sp_plan_dbccdb and sp_dbcc_evaluatedb in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Dalle
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.