Planning resources

Selecting the appropriate device and size for dbccdb is critical to the performance of dbcc checkstorage operations. sp_plan_dbccdb provides configuration recommendations for the specified target database depending on whether dbccdb exists or not. Use this information to configure Adaptive Server and set up the dbccdb database.