max worker processes 2
operation sequence number 1
(1 row affected)
(return status = 0)
Ø sp_dbcc_statisticsreport产生从dbcc_counter表中得到的统计信息
示例：
sp_dbcc_statisticsreport "aca_db","auths"
结果：
Parameter Name Index Id value
-------------- -------- -----
count 0 20.0
max size 0 88.0
max count 0 20.0
bytes data 0 1321.0
bytes used 0 1599.0
count 1 1.0
max count 1 1.0
max level 1 0.0
max size 1 11.0
bytes data 1 6.0
bytes used 1 43.0
count 255 0.0
max size 255 0.0
max count 255 0.0
bytes data 255 0.0
bytes used 255 0.0
Parameter Name Index Id Partition value Dev_name
-------------- -------- --------- ----- --------
page gaps 0 1 1.0 disk1
pages used 0 1 2.0 disk1
extents used 0 1 1.0 disk1
overflow pages 0 1 0.0 disk1
pages overhead 0 1 1.0 disk1
pages reserved 0 1 6.0 disk1
page extent gaps 0 1 0.0 disk1
ws buffer crosses 0 1 0.0 disk1
page extent crosses 0 1 0.0 disk1
page gaps 1 1 1.0 disk1
pages used 1 1 2.0 disk1
extents used 1 1 1.0 disk1
overflow pages 1 1 0.0 disk1
pages overhead 1 1 1.0 disk1
pages reserved 1 1 6.0 disk1
page extent gaps 1 1 0.0 disk1
ws buffer crosses 1 1 0.0 disk1
page extent crosses 1 1 0.0 disk1
page gaps 255 1 1.0 disk1
pages used 255 1 2.0 disk1
extents used 255 1 1.0 disk1
overflow pages 255 1 0.0 disk1
pages overhead 255 1 1.0 disk1
pages reserved 255 1 6.0 disk1
page extent gaps 255 1 0.0 disk1
ws buffer crosses 255 1 0.0 disk1
page extent crosses 255 1 0.0 disk1
Ø sp_dbcc_faultreport报告指定的数据库对象中发现的在指定日期或该日期之前发生的故障。可以生成短报告，也可以生成长报告。
示例：
sp_dbcc_faultreport 'short'
sp_dbcc_faultreport 'long'
****************************************************
dbcc checkstorage
产生的结果存放在dbccdb数据库的表里，如果你不delete history,它会一直保存的
dbcc checkdb,dbcc checkalloc,...
你只有定向输出到文件里
如果你在dbcc checkstorage 时，还有对数据库操作，结果会有歧义的
我现在backup前，只对关键的表作dbcc checktable,dbcc tablealloc等
我建议有条件的话，建立一个和生产机一样的数据库，将dump的数据库load到哪里，做
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.
(bigbug99
*****************************************************
很明显,你们的worker processes 不足!
(jazy)
*****************************************************
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
c
