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

Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page i Table of Contents Introduction...1 Tuning Goals...2 System Processor Planning ...2 Initial CPU Recommendations ...2 Memory Planning...3 Initial Memory Recommendations for Sybase 3 Estimating Memory Requirements for Sybase 3 Disk Subsystem Planning ...5 Array Accelerator: Its Function and Benefit in a Sybase SQL Server Environment 5 SMART and SMART-2 SCSI Array Controller characteristics 5 Write Cache...6 Read Cache...6 Housekeeper, Checkpoints, and Transaction Log Writes 6 Integrity of cached data in the Array Accelerator 7 Configuring the Array Accelerator 7 Fault Tolerance Considerations 9 1. RAID-based Disk Controllers 9 2. NetWare Disk Controller Duplexing 9 3. Sybase SQL Server Mirroring/Duplexing 9 Network Planning...10 Network Characteristics of a SQL Server Environment 10 IPX/SPX Network Packet Routing 10 TCP/IP Network Packet Routing 10 Network Interface Controller 11 Processor Tuning...11 Memory Tuning ...11 Estimating Memory Requirements for Stored Procedures 12 I/O Tuning ...12 Separate Sequential and Random I/O's 13 Layout of Tables and Files ...13 Checking Disk I/O Rate ...14 Network Tuning ...15 Compaq System Configuration ...15 NetWare 4.10 Configuration...15 Processes ...15 upgrade low priority threads 15 maximum service processes 16 Memory...16 garbage collection interval ...16 number of frees for garbage collection 16 minimum free memory for garbage collection 16 File Caching ...16 read ahead enabled...17 minimum file cache buffers...17 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896