Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 71
For example, if
procedure cache percent is configured as 20 percent of
200MB of memory, then the absolute value of
procedure cache percent is
40MB. During the upgrade process, Adaptive Server converts
procedure
cache percent
at 20 percent to procedure cache size at 40MB. If the value
for
procedure cache size is less than the default value, Adaptive Server sets
procedure cache size to the default value. For example, if procedure cache
percent
is set to 10 percent in the example above, and the absolute value
of 10 percent is less than the default value of
procedure cache size, then
procedure cache size is set to the default value.
With the introduction of dynamically reconfigured memory configuration
parameters in Adaptive Server 12.5.x, an increase in Adaptive Server’s
memory use does not decrease the size of the procedure cache or the data
cache. That is, if your default data cache is set to 40MB, and you increase
your procedure cache, the default data cache is still 40MB.
For more information about
sp_configure, see the Reference Manual.
5 Check the procedure cache requirements.
Stored procedures, triggers, and other compiled objects require more
memory to run than older versions. The memory required to run a stored
procedure increased by 20 percent between versions 10.x and 11.5.
Adaptive Server 12.5.x needs approximately 4 percent more procedure
cache than version 11.5 for the server to maintain the same performance.
You may increase the
procedure cache size during runtime, using
sp_configure. You can use the verify option in sp_configure to verify any
changes you make to the configuration file without having to restart
Adaptive Server. The syntax is:
sp_configure "configuration file", 0, "verify", "full_path_to_file"
For example:
sp_configure "configuration file", 0, "verify",
"/work2/Sybase/ASE125.cfg"
For more information about sp_configure and sp_sysmon, see the
Reference Manual and the Performance and Tuning Guide. For more
information about configuring memory, see the System Administration
Guide.
6 Verify data cache allocation after upgrading. This section is for
information only. Adaptive Server ensures that all the data cache sizes
after upgrading are the same as before upgrade.