Displaying configuration information for a target database

Use sp_dbcc_configreport to generate a report of the configuration information for a target database. The following example shows output from this command:

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