sp_dbcc_configreport

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

There are additional considerations when using sp_dbcc_configreport:

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.

See also dbcc in Reference Manual: Commands.

Permissions

The permission checks for sp_dbcc_configreport differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner of `dbccdb` (or `dbccalt`), or have the `report checkstorage`privilege on the specified database.
Disabled	With granular permissions disabled, any valid user for the database name specified can run sp_dbcc_configreport.