dbcc checkstorage命令详解(国外英语资料).docVIP

dbcc checkstorage命令详解(国外英语资料) The SYBASE database DBCC command details: DBCC checkstorage checks for the consistency of the database. The new version of the database is more useful than any DBCC command, especially before the database backup. The purpose of this article is to help you: Master DBCC checkstorage command Maintain DBCCDB database Generate reports according to DBCCDB In the case used in this article, you will first run the DBCC from the output of sp_plan_dbccdb The checkstorage command requires the resource environment and, based on this, the resource is planned, the DBCCDB database is established, and the DBCCDB database generates the report. This section exercises will be based on the following environment: There is a user database aca_db in the system with a capacity of 20MB (data 10MB, log 10MB) The aca_db database occupies two devices, disk1 and disk2 There are several user tables (auths, articles, etc.) in the aca_db database Steps are as follows: For the target database, the size of the database, the size of the device workspace, / cache size and the number of work processes. Sp_plan_dbccdb aca_db Execution results: Size for DBCCDB database is 15MB (data = 13MB, log = 2 MB). No suitable devices for DBCCDB in master. Sysdevices. The values for workspace size, cache size and process count Are: The dbname scan ws text ws cache process count Aca_db 272 k, 80 k, 1280 k 2 (return status = 0) Adjust the process number of Adaptive Server if necessary Create a named cache for the DBCC Configure a DBCC The checkstorage special named cache can not only improve performance but also minimize the impact of database consistency checking on other users. Dbcc Checkstorage requires that at least 640k of storage for each working process in the 16k memory pool of the named cache, the minimum capacity of the 16k memory pool is recommended for high cache capacity. Sp_cacheconfig aca_cache, 3072k (note: restarting the Adaptive Server will work) Configure the I/O cache