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