current text workspace size : 48K suggested text workspace size : 48K
current cache size : 640K suggested cache size : 640K
current process count : 1 suggested process count : 1
(return status = 0)
1>
(jimhongchen)
*****************************************************
我执行第一步结果如下，哪位大虾帮我搞个好的DBCC方案出来？多谢
1> sp_plan_dbccdb wxjj
2> go
Recommended size for dbccdb database is 38MB (data = 36MB, 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 process count
wxjj 18448K 4624K 4615K 2
(return status = 0)
(bigbug99
*****************************************************
Jazy, thank you.
I solved my problem after your hint.
bigbug99, you can use following command to increase the number of worker process.
1> sp_configure "number of worker processes", 1
2> go
Parameter Name Default Memory Used Config value Run value
------------------------------ ----------- ----------- ------------ -----------
number of worker processes 0 176 1 1
(1 row affected)
Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.
(return status = 0)
1>
