Compaq ProLiant 1000 Configuration and Tuning of Sybase System 11 for NetWare - Page 8

Page 4 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers For Sybase Monitor Server Module NetWare 4KB buffers Monitor Server 453 Total 453 Total in MB 2 48 MB SQL Server + 4 MB Backup Server + 2 MB Monitor Server = 54 MB total System 11 Add to this 51KB for each user connection beyond the initial default of 25 user connections. The value of 51KB per user connection may need to be increased depending upon if you also increased the user stack size and the default network packet size. Refer to the sections later in this document for a discussion on the implications of altering the user stack size and the default network packet size. Lets assume an additional 50 users, for a total of 75 user connections, at the default allocation of 51KB per user. 50 additional users * 51 KB per user connection = 2550 KB ≈ 2.5 MB For each database device beyond the initial 10 devices add another 0.5KB. For our example here lets assume the addition of 12 more devices. 12 additional devices * 0.5 KB per device = 6 KB ≈ 0.6 MB The type of transactions we are planning to execute will be transferring large amounts of data between the client and server. To reduce the number of packets transferred on the network we will increase the max network packet size from 512 to 4096 bytes. Each user connection requires 3 packet buffers. We will need to increase the setting for additional network memory to meet this requirement. 75 user connections * 3 buffers per user * 4096 bytes + 2% overhead = 940032 bytes ≈ 0.9 MB At this time we don't know how much memory will be required as procedure and data cache. We do know that we have approximately 5 GB worth of data. Lets' assume that we want 5% of the data in the data cache. Theoretically you could increase the amount memory in the system so the entire database would fit in memory, resulting in hopefully some rather phenomenal performance. But typically most databases are larger than the available memory of the server. 5% data in cache * 5 GB = 0.25GB = 256 MB So the initial estimate of how much memory is required by this implementation is: Estimate of Sybase System 11 Memory Requirement allocated by memory in MB Sybase System 11 54.0 50 additional users 2.5 12 additional devices 0.6 additional network memory 0.9 5% of data in cache 256.0 Total in MB 314.0 Total in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896