Compaq ProLiant 3000 White Paper

11 for NetWare on Compaq Servers White Paper ________________________________________________________________ Prepared By Database Engineering Compaq Computer Corporation August 1996 ...

COMPAQ COMPUTER CORPORATION SHALL NOT BE LIABLE FOR TECHNICAL OR EDITORIAL ERRORS OR OMISSIONS CONTAINED HEREIN, NOR FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES RESULTING FROM THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL. This publication contains information protected by cop ...

Page i  1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Table of Contents Introduction......................................................................................................................................... 1 Tuning Goals.................... ...

 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 File System................................................................................................................................... 17 volume block size...................................... ...

Doc No 140A/0896 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Introduction The purpose of this document is to share the knowledge acquired by Compaq Systems Engineers in the area of configuration and performance tuning of Sybase SQL Server 11 for Novell NetWare on the Com ...

 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Tuning Goals To achieve the best system performance possible, there are several factors which you must review. These factors include optimization of the hardware, the Sybase SQL Server, the operating s ...

Page 3  1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 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 mi ...

 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 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 e ...

Page 5  1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 For dedicated Sybase SQL Servers leave at least 10% of the original cache buffers as free cache buffers. For non-dedicated Sybase SQL Servers leave at least 20% of the original cache buffers as free c ...

 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Write Cache When the Array Accelerator performs write caching, the drive controller writes data to the cache memory on the Array Accelerator rather than directly to the drives. The system can access th ...