SYBASE dbcc

jazy

在进行sp_plan_dbccdb时，我觉得系统是根据某库所占有的设备数来给出number of worker processes 的推荐值，比如你的生产库使用了7个设备，那么将给出number of worker processes为7的推荐值！但是实际上你可以多配点，也可以相应的少配点，另外配置改参数需要reboot ASE，所以不可轻易在生产环境中进行修改！另外，在配置命名缓存时也需要进行reboot server!

jimhongchen

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>;

bigbug99

我前面配置都差不多，但执行到这里，怎么报错了？
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.

jazy

很明显,你们的worker processes 不足!

rekcah0

请问各位大师们:
1.dbcc checkstorage带不带fix功能?
2.如果我的系统完全能容忍我任意执行dbcc checkdb,dbcc checkalloc且我对输出内容的保存方式不敏感的话,dbcc checkstorage还比dbcc checkdb,dbcc checkalloc优越吗?

bigbug99

我执行第一步结果如下，哪位大虾帮我搞个好的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)

菜虾

收藏

jimhongchen

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>;