System Procedures for Configuring Memory

Use the sp_configure, sp_helpconfig, and sp_monitorconfig system procedures to configure SAP ASE memory.

The full syntax and usage of sp_configure and details on each parameter are discussed in System Administration Guide, Volume 1 > Setting Configuration Parameters.

• Viewing the Configuration Parameters for Memory
  Issue the Memory Use configuration parameter to view the parameters associated with memory use on SAP ASE.
• Using sp_helpconfig
  sp_helpconfig estimates the amount of memory required for a given configuration parameter and value. It also provides a short description of the parameter, information about the minimum, maximum, and default values for the parameter, the run value, and the amount of memory used at the current run value.
• Using sp_monitorconfig
  sp_monitorconfig displays metadata cache usage statistics for certain shared server resources.