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

Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers

Page 4 highlights

Page ii Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers File System...17 volume block size...17 enable file compression...17 sub-block allocation ...17 enable disk read after write verify 17 immediate purge of deleted files 18 file delete wait time...18 minimum file delete wait time 18 remirror block size...18 concurrent remirror requests 18 mirrored devices are out of sync message frequency 18 Communications...19 maximum physical receive packet size 19 minimum packet receive buffers 19 maximum packet receive buffers 19 NetWare Partitions ...19 Upgrading From Previous Sybase Versions to System 11 19 Sybase System 11 Configuration...19 sp_configure command ...20 total memory...20 procedure cache percent...20 number of devices ...20 number of user connections...20 recovery interval in minutes 20 housekeeper free write percent 21 user log cache size ...21 default network packet size ...21 max network packet size ...21 additional network memory...21 number of extent i/o buffers 21 number of sort buffers ...22 number of pre-allocated extents 22 stack size ...22 event buffers per engine ...22 Sybase Sybinit Utility...22 Sybase Audit Feature ...22 Installing From CD-ROM...23 Compaq SCSI based CD-ROM drive 23 Compaq IDE based CD-ROM drive 23 System Management Tools ...24 Novell Monitor Utility ...24 Sybase SQL Monitor...24 Compaq Insight Manager ...24 Conclusion ...25 Check List of Recommendations...26 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31

Page
ii
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
1996 Compaq Computer Corporation, All Rights Reserved
Doc No 140A/0896
File System
...................................................................................................................................
17
volume block size
...................................................................................................................
17
enable file compression
..........................................................................................................
17
sub-block allocation
...............................................................................................................
17
enable disk read after write verify
..........................................................................................
17
immediate purge of deleted files
.............................................................................................
18
file delete wait time
................................................................................................................
18
minimum file delete wait time
................................................................................................
18
remirror block size
.................................................................................................................
18
concurrent remirror requests
..................................................................................................
18
mirrored devices are out of sync message frequency
...............................................................
18
Communications
...........................................................................................................................
19
maximum physical receive packet size
...................................................................................
19
minimum packet receive buffers
.............................................................................................
19
maximum packet receive buffers
............................................................................................
19
NetWare Partitions
.......................................................................................................................
19
Upgrading From Previous Sybase Versions to System 11
.....................................................................
19
Sybase System 11 Configuration
..........................................................................................................
19
sp_configure command
.................................................................................................................
20
total memory
..........................................................................................................................
20
procedure cache percent
.........................................................................................................
20
number of devices
..................................................................................................................
20
number of user connections
....................................................................................................
20
recovery interval in minutes
...................................................................................................
20
housekeeper free write percent
...............................................................................................
21
user log cache size
.................................................................................................................
21
default network packet size
....................................................................................................
21
max network packet size
........................................................................................................
21
additional network memory
....................................................................................................
21
number of extent i/o buffers
...................................................................................................
21
number of sort buffers
............................................................................................................
22
number of pre-allocated extents
..............................................................................................
22
stack size
...............................................................................................................................
22
event buffers per engine
.........................................................................................................
22
Sybase Sybinit Utility
....................................................................................................................
22
Sybase Audit Feature
....................................................................................................................
22
Installing From CD-ROM
....................................................................................................................
23
Compaq SCSI based CD-ROM drive
............................................................................................
23
Compaq IDE based CD-ROM drive
..............................................................................................
23
System Management Tools
..................................................................................................................
24
Novell Monitor Utility
..................................................................................................................
24
Sybase SQL Monitor
.....................................................................................................................
24
Compaq Insight Manager
.............................................................................................................
24
Conclusion
..........................................................................................................................................
25
Check List of Recommendations
..........................................................................................................
26