The total memory Adaptive Server requires to start is the sum of all memory configuration parameters plus the size of the procedure cache plus the size of the buffer cache, where the size of the procedure cache and the size of the buffer cache are expressed in round numbers rather than in percentages. The procedure cache size and buffer cache size do not depend on the total memory you configure. You can configure the procedure cache size and buffer cache size independently. Use sp_cacheconfig to obtain information such as the total size of each cache, the number of pools for each cache, the size of each pool, and so on.
Use sp_configure to determine the total amount of memory Adaptive Server is using at a given moment. For example:
1> sp_configure "total logical memory"
Parameter Name Default Memory Used Config Value Run Value Unit Type -------------- -------------- --- ----------- ------------ --------- -------------------- ---------- total logical memory 33792 127550 63775 63775 memory pages(2k) read-only
The value for the Memory Used column is represented in kilobytes, while the value for the Config Value column is represented in 2K pages.
The config value indicates the total logical memory Adaptive Server uses while it is running. The run value column shows the total logical memory being consumed by the current Adaptive Server configuration. You see a different output if you run this example because no two Adaptive Servers are likely to be configured in exactly the same fashion.
For more information about sp_configure, see the Reference Manual Volume 3: Procedures.
