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