Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database.
sp_dbcc_configreport [dbname]
specifies the name of the database. If dbname is not specified, the report contains information on all databases in dbccdb..dbcc_operation_log.
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
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.
The permission checks for sp_dbcc_configreport differ based on your granular permissions settings.
Granular permissions 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. |
Granular permissions disabled |
With granular permissions disabled, any valid user for the database name specified can run sp_dbcc_configreport. |
Commands dbcc
dbcc stored procedures sp_dbcc_alterws, sp_dbcc_fullreport, sp_dbcc_statisticsreport, sp_dbcc_summaryreport, sp_dbcc_updateconfig
