Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page
i
1996 Compaq Computer Corporation, All Rights Reserved
Doc No 140A/0896
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