Use these system procedures to configure Adaptive Server memory:
sp_configure
sp_helpconfig
sp_monitorconfig
The full syntax and usage of sp_configure and details on each parameter are discussed in Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide, Volume 1.
