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

Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 3 Memory Planning The amount of memory in the server will have a great impact on the overall performance of the Sybase SQL Server. For NetWare servers dedicated as Sybase SQL Servers there should be a minimum of 10% free buffers are reported by the NetWare monitor utility. For non-dedicated NetWare servers, servers that perform file and print services along with running Sybase SQL Server, this value should be at least 20%. Initial Memory Recommendations for Sybase Sybase recommends a minimum of 64 MB of memory to install and run Sybase System 11. System 11 consists of Sybase SQL Server, Sybase Backup Server, Sybase Monitor Server and Sybase Historical Server. Adding additional memory to the server and configuring it for use by the Sybase SQL Server will in most cases increase the server throughput and performance. Estimating Memory Requirements for Sybase You can obtain an initial estimate the actual memory requirements for your Sybase System 11 database server by using the following procedures. The server used in this calculation had 512 MB of memory installed. Install Sybase SQL Server, Backup Server and Monitor using the default installed configurations. Restart NetWare and load the Novell Monitor utility. Record the number of original cache buffers and total cache buffers as reported on the Novell Monitor general information screen. We will use these numbers later in this calculation. Original Cache Buffers: 130,561 Total Cache Buffers: 122,256 Start SQL Server, Backup Server and Monitor Server. Use the Novell Monitor utility to record the memory allocation of the Sybase modules. The allocations on our test server were as follows: For Sybase SQL Server Module NetWare 4KB buffers International Library 6 Sybase Common Library 6 Sybase CS-Library 6 Netlib Driver for TLI 6 Sybase Transport Control Library 6 Sybase DB Library 6 Sybase SQLServer Stubs Library 6 Sybase SMP Stub Library 6 Sybase NetWare SQL Server 12008 Sybase Server Library 6 Total 12062 Total in MB 48 For Sybase Backup Server Module NetWare 4KB buffers Sybase Backup Server 929 Total 929 Total in MB 4 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896