Sybase Adaptive Server 15.0.2, Installation Manual

Page: 87 / 160

CHAPTER 5 Upgrading Adaptive Server
Installation Guide
73
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",
"C:\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.
In pre-12.5 versions of Adaptive Server, the default data cache available
depended on the amount of memory available to Adaptive Server. If the
default data cache was set to 2MB, Adaptive Server allocated 2MB to the
default data cache. If, after memory was allocated to all user-defined data
caches and to the procedure cache, there was more memory available, that
memory was allocated to the default data cache. However, if there was not
enough memory available for Adaptive Server to set up the user-defined
caches and the procedure cache, then memory was taken from the default
data cache regardless of the designated configuration parameter.
Therefore, it was possible to set default data cache to the default value and
have all remaining available memory allocated to the default data cache.
Adaptive Server 12.5.x and later treats the default data cache size as an
absolute value and sets it in the config file. The string DEFAULT in the
config file has a different meaning for default data cache size in Adaptive
Server 12.5.x and later.