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
