sp_monitorconfig adds the all parameter. The new syntax for sp_monitorconfig is:
sp_monitorconfig "configname" [, "result_tbl_name"]
or
sp_monitorconfig "all" [, "result_tbl_name"]
configname is all or part of the configuration parameter name whose monitoring information is being queried. Until Adaptive Server 12.5, the only valid configuration parameters were open indexes, open objects, open databases, aux scan descriptors, txn to pss ratio, number of dtx participants, and all. Specifying all displays descriptor help information for all indexes, objects, databases, and auxiliary scan descriptors in the server.
The number of configuration parameters sp_monitorconfig supports has been increased from 6 to 34.
