Before you can use dbcc checkstorage, you must set up the dbccdb database. Table 5-6 lists the system and stored procedures for creating dbccdb. sp_plan_dbccdb is the only system procedure. It resides in sybsytemprocs. sp_dbcc_createws and sp_dbcc_updateconfig are dbcc stored procedures. They reside in dbccdb.
Procedure |
Description |
|---|---|
sp_dbcc_createws |
Creates a workspace of the specified type and size on the specified segment and database. |
sp_dbcc_updateconfig |
Updates the configuration parameters for the specified database. |
sp_plan_dbccdb |
Recommends values for the size of dbccdb, suitable devices, sizes for the scan and text workspaces, cache size, and the number of worker processes for optimal operation. |
