
Migrating to Sybase Adaptive Server Enterprise 11.5 6-13
Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.x
Space in your machine’s physical memory (RAM) is apportioned
roughly as depicted in Figure 6-1.
Figure 6-1: Areas of memory
The areas and their functions are:
Operating system. This part of the physical space is used by the
operating system and other non-Sybase processes running on the
machine.
Shared memory. This is rest of the physical memory, which is
allocated to Adaptive Server by the operating system.
Server processes and structures. This area includes the
dataserver
program and the server kernel, which manages Adaptive Server.
This area also includes space for structures like locks and user
connections. These processes and structures take as much of the
shared memory as they need.
Procedure cache. This area is used by compiled objects that execute,
such as stored procedures, triggers, and views. Procedure cache
grabs a set percentage (the
procedure cache percent set by sp_configure) of
the remaining shared memory.
Data cache. This area is where pages of data are kept in memory. In
general, the more data pages that are kept in memory, the less disk
Operating System
Server Processes
Procedure Cache
Data Cache
Server Executable
and Structures
Shared
Memory
Commenti su questo manuale