Home

	Expand Search

Reference Manual All Volumes (Online Only)

Chapter 6: dbcc Stored Procedures

Chapter 6

This chapter describes the dbcc stored procedures. These procedures access the tables only in the dbccdb database or in the alternate database, dbccalt. For details on setting up dbccdb or dbccalt, see Chapter 18, "Checking Database Consistency," in the System Administration Guide. For information on the tables in these databases, see Chapter 19, "dbccdb Tables" in the System Administration Guide.

Table 6-1 lists the dbcc stored procedures described in this chapter. For details on the dbcc system procedure sp_plan_dbccdb, see sp_plan_dbccdb. For more information on this system procedure and the dbcc stored procedures, see Chapter 18, "Checking Database Consistency," in the System Administration Guide.

Table 6-1: dbcc stored procedures

Procedure Name	Description
sp_dbcc_alterws	Changes the size of the specified workspace to a specified value, and initializes the workspace.
sp_dbcc_configreport	Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database.
sp_dbcc_createws	Creates a workspace of the specified type and size on the specified segment and database.
sp_dbcc_deletedb	Deletes from dbccdb all the information related to the specified target database.
sp_dbcc_deletehistory	Deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time.
sp_dbcc_differentialreport	Generates a report that highlights the changes in I/O statistics and faults that took place between two dbcc operations
sp_dbcc_evaluatedb	Recomputes configuration information for the target database and compares it to the current configuration information.
sp_dbcc_faultreport	Generates a report covering fault statistics for the dbcc checkstorage operations performed for the specified object in the target database on the specified date.
sp_dbcc_fullreport	Runs sp_dbcc_summaryreport, sp_dbcc_configreport, sp_dbcc_statisticsreport, and sp_dbcc_faultreport short for database..object_name on or before the specified date.
sp_dbcc_runcheck	Runs dbcc checkstorage on the specified database, and then runs sp_dbcc_summaryreport or a report you specify
sp_dbcc_statisticsreport	Generates an allocation statistics report on the specified object in the target database.
sp_dbcc_summaryreport	Generates a summary report on the specified database. .
sp_dbcc_updateconfig	Updates the dbcc_config table in dbccdb with the configuration information of the target database.

Specifying the Object Name and Date

Manual Pages for DBCC Stored Procedures