The three system procedures to use for configuring Adaptive Server memory are:
sp_configure
sp_helpconfig
sp_monitorconfig
The full syntax and usage of sp_configure and details on each configuration parameter are covered in see Chapter 5, “Setting Configuration Parameters.”