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

Permissions

Any user can run sp_dbcc_configreport.

See also

Commands dbcc

dbcc stored procedures sp_dbcc_alterws, sp_dbcc_fullreport, sp_dbcc_statisticsreport, sp_dbcc_summaryreport, sp_dbcc_updateconfig