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

Configuration and Tuning of Sybase System 11 for Microsoft Windows NT on Compaq Servers Page i Table of Contents Introduction...1 Planning and Installation...1 Domain Controller, Backup Domain Controller or Server 1 System Processor Planning ...2 UniProcessor and MultiProcessor Support from Compaq 2 Processor Scalability ...2 Memory Planning ...3 Initial Memory...3 Virtual Memory ...4 Disk Subsystem Planning...4 Array Accelerator: Its Function and Benefit in a Sybase SQL Server Environment 4 Checkpoints, Housekeeper and Transaction Log Writes 4 Fault Tolerance Considerations 5 1. RAID-based Disk Controllers 6 2. Windows NT-based RAID 6 3. Sybase SQL Server Mirroring/Duplexing 6 FAT vs. NTFS ...7 Compaq System Configuration Utility Considerations 7 Network Planning...8 Network Characteristics of a Sybase SQL Server Environment 8 Network Protocols: Packet Sizes 8 Multiple Network Protocols 9 Performance Monitoring and Tuning 9 System Processor Utilization, Monitoring and Optimization 9 Optimizing Windows NT & SQL Server Operations 9 Unnecessary Services ...10 CPU Performance Monitor Objects and Their Meaning 11 Memory Utilization, Monitoring and Optimization 11 Window NT Paging: Detection and Avoidance 11 Sybase SQL Server Tuning Parameters 12 Memory ...12 Dbcc Memusage...13 Procedure Cache ...13 Disk Subsystem Utilization, Monitoring and Optimization 13 Recovery Interval...13 Diskperf...14 Disk Performance Monitor Objects and Their Meaning 14 Sybase SQL Server ...15 Runserver Command File and the Windows NT Registry 15 Sybaudit Performance Considerations 15 Compaq Insight Manager ...15 Conclusion ...17 Check List of Recommendations 17 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 143A/0596