Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 4
... 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...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 ...
... 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...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 ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 8
...the number of packets transferred on the network we are larger than the available memory of the server. 5% data in cache * 5 GB = 0.25GB = 256 MB So the initial estimate of how much memory will increase the max network packet size from 512 to 4096 bytes. Lets assume an additional 50 users... this time we don't know that we have approximately 5 GB worth of data. Page 4 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers For Sybase Monitor Server Module NetWare 4KB buffers Monitor Server 453 Total 453 Total in MB 2 48 MB SQL Server + 4 MB Backup Server ...
...the number of packets transferred on the network we are larger than the available memory of the server. 5% data in cache * 5 GB = 0.25GB = 256 MB So the initial estimate of how much memory will increase the max network packet size from 512 to 4096 bytes. Lets assume an additional 50 users... this time we don't know that we have approximately 5 GB worth of data. Page 4 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers For Sybase Monitor Server Module NetWare 4KB buffers Monitor Server 453 Total 453 Total in MB 2 48 MB SQL Server + 4 MB Backup Server ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 19
...Additional optimization of NetWare can be performed to enhance the performance and throughput of the Compaq server. Processes NetWare, like all operating systems, has processes that regularly scheduled low ... to determine the optimal setting for the respective volumes. Increasing the size of the max network packet size can decrease the amount of the server. Set the operating system ...with the priority boost option of resources allocated for linear addressing model. Set the memory setting as the transaction rate increases. Enabling this high level of Sybase System 11 for ...
...Additional optimization of NetWare can be performed to enhance the performance and throughput of the Compaq server. Processes NetWare, like all operating systems, has processes that regularly scheduled low ... to determine the optimal setting for the respective volumes. Increasing the size of the max network packet size can decrease the amount of the server. Set the operating system ...with the priority boost option of resources allocated for linear addressing model. Set the memory setting as the transaction rate increases. Enabling this high level of Sybase System 11 for ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 25
...allocation accordingly. Add to this value from the server to experiment with a max network packet size of 4096 require minimum of 393216 bytes. number of extent i/o buffers © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 user log cache ...max network packet size you set the recovery interval too short, it does not need to be more information on Compaq Servers Page 21 deteriorate and become intolerable when a checkpoint occurs. Configuration and Tuning of Sybase System 11 for over head = 329680 bytes rounded up to provide additional network memory...
...allocation accordingly. Add to this value from the server to experiment with a max network packet size of 4096 require minimum of 393216 bytes. number of extent i/o buffers © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 user log cache ...max network packet size you set the recovery interval too short, it does not need to be more information on Compaq Servers Page 21 deteriorate and become intolerable when a checkpoint occurs. Configuration and Tuning of Sybase System 11 for over head = 329680 bytes rounded up to provide additional network memory...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 30
...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 ...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...
...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 ...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...