Chapter 4: dbcc Stored Procedures

sp_dbcc_configreport

Description

Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database.

Syntax

sp_dbcc_configreport [dbname]

Parameters

dbname: specifies the name of the database. If dbname is not specified, the report contains information on all databases in dbccdb..dbcc_operation_log.

Examples

Example 1

Generates a report on the configuration information related to dbcc for the sybsystemprocs database. The “Value” column lists the object name, where applicable, and the size:

sp_dbcc_configreport

Reporting configuration information of database sybsystemprocs.

Parameter Name              Value                         Size

database name               sybsystemprocs                51200K
dbcc named cache            default data cache            1024K
text workspace              textws_001 (id = 544004969)   128K
scan workspace              scanws_001 (id = 512004855)   1024K
max worker processes        1
operation sequence number    2

Usage

sp_dbcc_configreport generates a report that describes the configuration information used by dbcc operations for the specified database. This information is stored in the dbcc_config table.
To evaluate the most current configuration parameters, run sp_dbcc_updateconfig before running sp_dbcc_configreport.
To change the configuration values for a workspace, use sp_dbcc_alterws.

Permissions

Any valid user for the database name specified can run sp_dbcc_configreport.database name specified.