哪里,做
dbcc checkstorage,如果发现错误,修正后,再load回生产机
我现在就这么干
(freebob)
****************************************************
dbcc checkstorage 命令的执行速度最快,检查最全面,而且只产生共享锁,应该是最好的选择
(chuxu 
****************************************************
我前面配置都差不多,但执行到这里,怎么报错了?
1> dbcc checkstorage(wxjj)
2> go
Checking wxjj: Logical pagesize is 2048 bytes
Msg 9961, Level 17, State 6:
Server 'wxjj', Line 1:
DBCC failed to connect to the requested number of worker processes. The number
of workers configured is insufficient, or the number of workers exceeds 128. Use
sp_dbcc_updateconfig to reduce 'max worker processes' for this database.
Msg 9960, Level 20, State 1:
Server 'wxjj', Line 1:
A non-recoverable error has occurred in the CHECKSTORAGE operation. The
operation has been aborted.
DBCC CHECKSTORAGE for database 'wxjj' encountered an error. Some results may not
be available. Correct the problems reported and reexecute the CHECKSTORAGE
command.
I performed all commands needed for creating dbccdb for pubs2.
Why do I have the following error message?
I used "sp_dbcc_evaluatedb" to check and every thing seemed to be ok.
1> dbcc checkstorage (pubs2)
2> go
Checking pubs2
Msg 9961, Level 17, State 3:
Line 1:
DBCC failed to connect to the requested number of worker processes. The number of workers configured is insufficient, or the number of workers exceeds 128. Use sp_dbcc_updateconfig to reduce 'max worker processes' for this database.
Msg 9960, Level 20, State 1:
Line 1:
A non-recoverable error has occurred in the CHECKSTORAGE operation. The operation has been aborted.
DBCC CHECKSTORAGE for database 'pubs2' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command.
1>
2> reset
1> sp_dbcc_evaluatedb
2> go
Recommended values for workspace size, cache size and process count are:
Database name : pubs2
current scan workspace size : 64K suggested scan workspace size : 64K
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>