All processes in Adaptive Server share a pool of lock structures. As a first estimate for configuring the number of locks, multiply the number of concurrent user connections you expect, plus the number of worker processes that you have configured, by 20. The number of locks required by queries can vary widely. See “number of locks” on page 171 for more information. For information on how worker processes use memory, see “Worker processes”.
Copyright © 2005. Sybase Inc. All rights reserved. |