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

Page 26 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Check List of Recommendations Initial recommendations for Sybase SQL Server 11.0.1 system running on Novell NetWare 4.10: • Design your database with performance in mind from the start • Start with minimum of 64 MB RAM • Avoid memory fragmentation, do not load and unload unnecessary NLMs and utilities at the server • Perform administrative tasks at client workstation whenever possible • Check revision levels of Novell files, update to newer revisions • Dedicate the server to Sybase SQL Server, use other servers for file and print services • Use SMART and SMART-2 SCSI Array Controllers with array accelerator enabled for increased performance • Use SMART and SMART-2 SCSI Array Controllers hardware fault tolerance features • Use 64KB block factor when setting up NetWare partitions • Disable sub-block allocation and file compression when setting up NetWare partitions • Use Novell controller duplexing with caution, CPU overhead can impact performance • Use Sybase database mirroring with caution, CPU overhead can impact performance • Use database striping methods to balance workload across multiple controllers • Standardize on one network protocol and frame type • Use Compaq Insight Manager to monitor system hardware, CPU utilization, EISA bus utilization, software and firmware revisions • Load sqlsrvr with the -P option on dedicated systems • Use Sybase SQL Monitor to monitor CPU utilization, memory allocations and device I/O rates • Use stored procedures to reduce network traffic and server CPU load • Use System Configuration Utility setting of Novell NetWare as operating system choice for Server, SMART and SMART-2 SCSI Array Controller(s) • Increase the value of the max network packet size to help minimize elapsed times for database load activities like BCP and reduce CPU workload at the server • Install the Sybase Sybaudit device on separate disk partition for optimal performance • Upgrade to NetWare 4.10 before upgrading to Sybase System 11 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896