Progress
Database Administration
Guide and Reference
Controlling Memory Use
Table 14–1 lists the startup parameters used to fine-tune memory allocation on the server system.
Table 14–1: Startup Parameters That Affect Memory Allocation Startup Parameter Suggested Use Blocks in Database Buffers (-B
) Increasing the buffer size decreases the amount of database record I/O by increasing the number of buffers available in memory. This increases memory usage. Increase the -B
parameter to use more memory to reduce I/O. Decrease the -B
parameter if memory is limited or if database buffer I/O causes paging. Maximum Clients per Server (-Ma
)1 If some number of remote clients overloads the server or exhausts the file descriptors on a system, set this parameter to limit the number of clients. Maximum Servers (-Mn
)1 If a server becomes overloaded with clients, set this parameter to limit the number of servers. If you significantly increase this parameter, you should also increase the Minimum Clients per Server (-Mi
) parameter. Number of Users (-n
) On nonshared-memory systems, use this parameter to limit the total number of users below the level that overloads the database server.On shared-memory systems, set this parameter large enough to include both local and remote users.
Pin Shared Memory (-pinshm
) Use this parameter to prevent the database engine from swapping shared memory contents to disk.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |