HP ProLiant 800 Configuration and Tuning of Sybase System 11 for NetWare on Co
HP ProLiant 800 Manual
View all HP ProLiant 800 manuals
Add to My Manuals
Save this manual to your list of manuals |
HP ProLiant 800 manual content summary:
- HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 1
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers White Paper Prepared By Database Engineering Compaq Computer Corporation August 1996 - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 2
of their respective companies. © 1996 Compaq Computer Corporation All rights reserved. Printed in the USA COMPAQ, SYSTEMPRO, PROLIANT, PROSIGNIA Registered US Patent and Trademark Office. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers First Edition (August 1996) Document - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 3
9 3. Sybase SQL Server Mirroring/Duplexing 9 Network Planning...10 Network Characteristics of a SQL Server Environment 10 IPX/SPX Network 15 Compaq System Configuration ...15 NetWare 4.10 Configuration...15 Processes ...15 upgrade low priority threads 15 maximum service processes 16 Memory... - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 4
and Tuning of Sybase System 11 for NetWare on Compaq Servers File System...17 volume block size...17 enable file 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 - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 5
Engineers in the area of configuration and performance tuning of Sybase SQL Server 11 for Novell NetWare on the Compaq ProLiant family of servers. It is our desire to deliver the best technical information possible on a specific topic in a timely manner and in a highly useable format. Any comments - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 6
Compaq Servers Tuning Goals To achieve the best system performance possible, there are several factors which you must review. These factors include optimization of the hardware, the Sybase SQL Server outstanding I/Os. Users should see following problems: • processing power left Pentium®/133 or Pentium - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 7
and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 3 Memory Planning The amount of memory in the server will have a great impact on the overall performance of the Sybase SQL Server. For NetWare servers dedicated as Sybase SQL Servers there should be a minimum of 10% free buffers - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 8
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 + 2 MB Monitor Server = 54 MB total System 11 Add to this 51KB for each user connection beyond the initial default - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 9
manuals: s Configuring Compaq RAID Technology for Database Servers, Compaq TechNote, P/N 184206-001 s Compaq SMART-2 Array Controller User Guide, P/N 184482-001 s Compaq SMART SCSI Array Controller User Guide, P/N 142136-004 s Sybase SQL Server System Administration Guide controller is supported by - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 10
Compaq Servers Write Cache When the Array Accelerator performs write caching, the drive controller writes data to the cache memory on the Array Accelerator rather than directly to the drives. The system can access this cache memory housekeeper can help alleviate this problem. YThe transaction log - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 11
of Sybase System 11 for NetWare on Compaq Servers Page 7 Integrity of cached data in the Array Accelerator The Array Accelerator contains batteries that maintain any data in the cache if a system power failure occurs. Make sure you maintain the batteries in a good condition and fully charged (they - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 12
Page 8 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers The figure below shows how to enable/disable the Array Accelerator for a particular logical drive. Using the Array Configuration Utility, highlight the appropriate logical volume - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 13
omitted supplying Compaq RAID Technology for Database Servers for a more complete discussion. 2. NetWare Disk Controller Duplexing Y Operating system level mirroring through NetWare offers good reliability and provides fault tolerance when a disk controller should fail but it requires manual - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 14
SQL Server for NetWare supports server should be an End Node server not a TCP/IP Routing system. Use the NetWare Inetcfg utility to view and modify the IP packet forwarding setting. If the Inetcfg utility asks to "Transfer LAN driver, protocol and remote access commands?" reply with © 1996 Compaq - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 15
environment you have allocated most of the servers memory to the database leaving the remainder for other NetWare processes to use. The key to memory tuning then is how to instruct Sybase SQL Server to best use the memory allocated to it. The amount of memory allocated to the database can be altered - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 16
. To estimate the memory requirements for a stored Server Performance and Tuning Guide for more detailed information. I/O Tuning In most well tuned Sybase systems, I/O is not a limiting factor. In order to assure that this is not a problem, the following factors need to be verified. © 1996 Compaq - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 17
the transaction logs, such as the OS partition. In typical multi-user database systems, data access is random. This data should be spread Compaq TechNote, Configuring Compaq RAID Technology for Database Servers. Layout of Tables and Files In order to improve performance where disk I/O is a problem - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 18
Page 14 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers measured rates of up to 90 random I/Os per second per drive, some of which were being temporarily cached by the Array Accelerator. Checking Disk I/O - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 19
. If you prefer to run the Compaq System Configuration utility manually, outside of the SmartStart process, you will need to set the following items for optimal operation of your server under NetWare. Set the operating system to NetWare. Set the memory setting as linear for linear addressing model - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 20
Compaq SmartStart installation process is sufficient. Use the Monitor nlm, General Information screen to report on the maximum server processes currently loaded. If this number approaches the current setting consider increasing the initial value for maximum service processes. Memory Most problems - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 21
and applications by many users. Sybase bypasses the standard Server volume block size Set the volume block size to 64K during the creation of the volume from the Compaq to dedicate to Sybase memory structures. enable file for some disk device drivers you are enabling them to perform direct I/O - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 22
Compaq Servers in the early days of NetWare when disk drives had reliability problems. It is no longer necessary with the high levels of reliability that disk drives today have. In fact , when enabled, some NetWare disk device drivers time that will elapse after the user deletes a file and the start - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 23
SMART SCSI Array Controller User Guide and the Compaq SMART-2 Array Controller User Guide for more detailed information. Upgrading From Previous Sybase Versions to System 11 If you are running a previous version of Sybase SQL Server on NetWare 3.11/3.12 or NetWare 4.0x it is recommended that you - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 24
System 11 for NetWare on Compaq Servers It is possible to configure the parameters such that you cannot start SQL Server. If this happens, you memory estimate. number of user connections The number of user connections can greatly impact the amount of memory required by Sybase SQL Server. Each user - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 25
fewer packets need to be assembled for transmission from the server to the client. additional network memory Each user has 1536 bytes of network memory that is calculated in the base memory requirements for the user. Additional network memory is necessary when you increase the size of the max - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 26
Tuning of Sybase System 11 for NetWare on Compaq Servers Increasing the number of extent i/o buffers can user connection. If you increase the user stack size, recalculate the per user connection and initial memory requirement estimate. Refer to the Sybase SQL Server System Administration Guide - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 27
configured and tuned server, enabling this feature will have minimal impact the overall performance of the server. The audit Compaq CD-ROM drive you will need to load the following device drivers either in Startup.ncf or manually before you can access the CD-ROM drive as a NetWare volume. Compaq - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 28
notify you in cases of a catastrophic server hardware or software failure • check for latest updates to system and disk drive firmware • check for latest updates of device drivers • provide performance and resource utilization information © 1996 Compaq Computer Corporation, All Rights Reserved Doc - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 29
System 11 for NetWare on Compaq Servers Page 25 Conclusion The information in this paper is not a complete tuning guide but a supplement to other given here have been tested extensively, do not assume that tuning a specific parameter will always give the desired result. Do not be afraid to - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 30
, EISA bus utilization, software and firmware revisions • Load sqlsrvr with the -P option on dedicated systems • Use Sybase SQL Monitor to monitor CPU utilization, memory allocations and device I/O rates • Use stored procedures to reduce network traffic and server CPU load • Use System Configuration - HP ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare on Co - Page 31
Server Y Sybase System 10 Y Sybase System 11 Y Oracle 7 YOther: YYYY Processing Type On-Line Transaction Processing Decision Support Server Y Other: RDBMS Y Microsoft SQL Server Y Sybase System 10 Y Sybase System 11 Y Oracle 7 YOther: Additional Comments: Return to: Database Engineering Compaq
Configuration and Tuning of Sybase System
11 for NetWare on Compaq Servers
White Paper
________________________________________________________________
Prepared By
Database Engineering
Compaq Computer Corporation
August 1996