Compaq 6400R Configuration and Tuning of Sybase System 11 for NetWare on Compa
Compaq 6400R - ProLiant - 1 GB RAM Manual
UPC - 743172763259
View all Compaq 6400R manuals
Add to My Manuals
Save this manual to your list of manuals |
Compaq 6400R manual content summary:
- Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 2
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 Number 140A/0896 Compaq Computer - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 3
and Tuning of Sybase System 11 for NetWare on Compaq Servers Page i 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 4
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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 5
for Database Servers, Compaq TechNote, P/N 184206-001 • Sybase SQL Server™ System Administration Guide • Sybase SQL Server™ Performance and Tuning Guide • Introduction to Sybase® SQL Server™ for NetWare® • Installing Sybase® Products for Novell NetWare® • Using Sybase® SQL Server™ Utility Programs - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 6
that need to be considered before deciding on which CPU to utilize for your database server. Initial CPU Recommendations The choice of the right system processor depends on your environment. As technology evolves, more powerful processors are becoming available, pushing performance to new levels at - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 7
System 11 database server by using the following procedures. The server used in this calculation had 512 MB of memory installed. Install Sybase SQL Server, Backup Server and Monitor using the default installed configurations. Restart NetWare and load the Novell Monitor utility. Record the number - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 8
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 + 2 MB Monitor Server = 54 MB total System 11 Add to this 51KB for each - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 9
in the following 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, Doc. ID - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 10
System 11 for NetWare on 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 SQL Server generates a large number problem - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 11
, the batteries can preserve data in the Array Accelerator for four days. When power is restored to your system, an initialization feature writes the preserved data to the disk drives. Another step to insure data integrity in case of system failure is to install an Uninterruptible Power Supply (UPS - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - 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 and use the "Logical Drive/Modify..." - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 13
omitted supplying performance system processor. This type of RAID is totally transparent to the operating system and the applications. With a CPU-intensive application/environment, such as Sybase SQL Server, hardware-based fault tolerance can provide the best performance. Please refer to the Compaq - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 14
database 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 Computer Corporation - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 15
processes. If the Sybase SQL Monitor consistently reports CPU utilization over 75% you should consider upgrading the server to a faster processor. Memory Tuning In a typical Sybase SQL Server environment you have allocated most of the servers memory to the database leaving the remainder for other - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 16
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers transactions per minute, normalized CPU % idle 1.00 0.90 0.80 0.70 0.60 0.50 0.40 0.30 0.20 0.10 0.00 1.00 2.00% 1024 Sybase System 11 on NetWare 4.10 0.91 0.73 9.00% 3.00% 768 512 system memory in MB 27.00% 30 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 17
logs, such as the OS partition. In typical multi-user database systems, data access is random. This data should be spread out over as 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 18
Page 14 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers measured rates of up to 90 random rate per drive, first determine the number of I/O's per second to each logical volume. The Novell Monitor utility reports on the number of concurrent disk requests that are queued - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 19
initial hardware configuration of the Compaq server. The Compaq SmartStart installation process will automatically set the following hardware configuration items correctly for you. If you prefer to run the Compaq System Configuration utility manually, outside of the SmartStart process, you will need - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 21
the number of Server volume block size Set the volume block size to 64K during the creation of the volume from the Compaq SmartStart process or from the NetWare Install nlm. This parameter defines the minimum block size that the NetWare file system memory structures drivers you are enabling them - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 22
and Tuning of Sybase System 11 for NetWare on 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 ignore the setting - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 23
LAN segment. Set this to the largest packet size supported by your protocol and network interface boards. Larger numbers will simply be a waste of memory because the packets will not be utilizing that memory space, but the operating system will still have it allocated to the packet buffers. Setting - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 24
users onto the system. total memory The value for total memory determines the number of Sybase pages that Sybase SQL Server allocates at startup on the Resource Utilization screen. procedure cache percent The value for procedure cache is expressed as a percentage of the memory that is used for - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 25
System 11 for NetWare on Compaq Servers Page 21 deteriorate and become intolerable when a checkpoint occurs. If you set the recovery interval too short, it wastes valuable system processor can reduce the number of packets being transmitted on the network. Increasing this value from 512 bytes to - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 26
buffer consists of 8 Sybase pages or 16KB. Remember to include this memory allocation in your initial estimate. Refer to the Sybase SQL Server System Administration Guide for more information. number of sort buffers Increasing the number of sort buffers can reduce the time to create an index or re - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 27
Controller will be necessary. Installing From CD-ROM To install Sybase System 11 from the 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 SCSI based CD-ROM drive LOAD CPQSXPT - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 29
Tuning of Sybase System 11 for NetWare on Compaq Servers Page 25 Conclusion The information in this paper is not a complete tuning guide but a 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 30
protocol and frame type • Use Compaq Insight Manager to monitor system hardware, CPU utilization, 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 - Compaq 6400R | Configuration and Tuning of Sybase System 11 for NetWare on Compa - Page 31
form to help us keep you up to date with future revisions of this document and related new Title: Company: Address: Phone Number: Please evaluate the quality of Server Y Sybase System 10 Y Sybase System 11 Y Oracle 7 YOther: YYYY Processing Type On-Line Transaction Processing Decision Support
Configuration and Tuning of Sybase System
11 for NetWare on Compaq Servers
White Paper
________________________________________________________________
Prepared By
Database Engineering
Compaq Computer Corporation
August 1996