Compaq ProLiant 800 Configuration and Tuning of Sybase System 11 for NetWare o
Compaq ProLiant 800 Manual
View all Compaq ProLiant 800 manuals
Add to My Manuals
Save this manual to your list of manuals |
Compaq ProLiant 800 manual content summary:
- Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - 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 ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 2
for internal use distribution, no part of this publication may be photocopied or reproduced in any form without prior written consent from Compaq Computer Corporation. This publication does not constitute an endorsement of the product or products that were tested. The configuration or configurations - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 3
and Random I/O's 13 Layout of Tables and Files ...13 Checking Disk I/O Rate ...14 Network Tuning ...15 Compaq System Configuration ...15 NetWare 4.10 Configuration...15 Processes ...15 upgrade low priority threads 15 maximum service processes 16 Memory...16 garbage collection interval ...16 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 4
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 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 5
customer-reported expectations, performance trends, and solutions. Sybase and Compaq do not recommend or support the Compaq RAID Technology for Database Servers, Compaq TechNote, P/N 184206-001 • Sybase SQL Server™ System Administration Guide • Sybase SQL Server™ Performance and Tuning Guide - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 6
System 11 for NetWare on Compaq Servers Tuning Goals To achieve CPU will always have some work to do while there are outstanding I/Os. Users should see good response times. A system that appears to be tuned well and is experiencing poor response times could have any or all of the following problems - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 7
and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 3 Memory Planning The amount of memory in by the NetWare monitor utility. For non-dedicated NetWare servers, servers that perform file and print services along with running Sybase SQL Server, this value should be at least 20%. - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - 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 Total in MB 314.0 Total in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - 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 every logical volume on this controller is supported by the Array Accelerator in the 50/ - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 10
and Tuning of Sybase System 11 for NetWare on Compaq Servers Write Cache When the Array Accelerator performs write pending at the controller. Proper tuning of the housekeeper can help alleviate this problem. YThe transaction log activity is composed exclusively of sequential writes and does - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 11
obtain the latest copy of the appropriate utility for your Compaq SMART and SMART-2 Array controllers. With the SMART Array controller, the Array Accelerator can either be enabled (100% write cache) or disabled. This controller does not support read-ahead. The Array Accelerator can be enabled or - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - 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 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 13
a CPU-intensive 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 Guide - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 14
Tuning of Sybase System 11 for NetWare on Compaq Servers Y Sybase SQL Server supports both serial and nonserial write mode of mirroring. the Packet Forwarding setting. The changes are saved in the sys:etc\initsys.ncf file. Restart the server for these changes to take effect. TCP/IP Network Packet - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 15
Compaq Servers Page 11 "yes". From the Internetworking Configuration, Protocols, TCP/IP selection screen display, disable the IP Packet Forwarding setting. The changes are saved in the sys:etc\initsys.ncf file file and print services and other CPU tuning then is how to instruct Sybase SQL Server to - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 16
for NetWare on Compaq Servers transactions per minute, normalized CPU % idle 1. 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 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 17
disks. For more information on optimizing array configurations refer to the 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, keep in mind the following. • Transaction log access is 100 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - 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, following I/O device rates for the data devices: acct1: 42 reads + 28 writes © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 19
experience any significant throughput problems as the transaction rate of network traffic, decrease the CPU workload at both the client and to run the Compaq System Configuration utility manually, outside of NetWare is highly optimized for file and print sharing services. Fortunately this high level - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 20
for maximum service processes. Memory Most problems occur when File caching is not important to the performance of Sybase SQL Server on dedicated or nondedicated systems. Sybase SQL Server uses the directfs nlm to bypass the NetWare file caching and directly access its database files. © 1996 Compaq - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 21
not necessary. sub-block allocation Disable sub-block allocation during the creation of the volume from the Compaq SmartStart process or from the NetWare Install nlm. Sub-block allocation allows multiple files to exist within one NetWare volume block. When sub-block allocation is enabled, multiple - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 22
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 after the user deletes a file and the start of the purge process. This setting is irrelevant when immediate purge of deleted files is set to on. - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 23
while the processor is busy servicing other requests. Set this receive buffers in the Startup.ncf file and restart the server. You Compaq SMART SCSI Array Controller User Guide and the Compaq SMART-2 Array Controller User Guide System 11. Compaq and Sybase do not recommend or support Sybase System 11 - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 24
and Tuning of Sybase 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 can use a normal text file editor like Novell Edit to access the sys:\servername.cfg file and set the offending parameter to a more - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 25
11 for NetWare on Compaq Servers Page 21 at its default setting. When the housekeeper process detects idle CPU time it begins to flush data pages to the disk at Refer to the Sybase SQL Server Performance and Tuning Guide for more information on checkpoints and the housekeeper processes. - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 26
your initial estimate. Refer to the Sybase SQL Server System Administration Guide for more information. number of sort buffers Increasing the number of this file looking for your server name to use in the definition of the listener server for TCP/IP. Sybase Audit Feature © 1996 Compaq Computer - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 27
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 LOAD CPQS710 LOAD CPQSCD LOAD CPQSDSK LOAD NWPALOAD LOAD CDROM ... CD Purge ... CD Volume List - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 28
is notified of any fault in the system and that corrective action is taken quickly. The Novell Monitor nlm utility, Sybase SQL Monitor and Compaq Insight Manager are to be considered as a good starting point for most environments. There are many third party utilities that can further enhance the - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 29
Configuration and 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 supplement to other tuning information provided by Sybase and Novell. To achieve an optimal configuration, there are several factors to - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 30
Dedicate the server to Sybase SQL Server, use other servers for file and print services • Use SMART and SMART-2 SCSI Array Controllers with array one network protocol and frame type • Use Compaq Insight Manager to monitor system hardware, CPU utilization, EISA bus utilization, software and firmware - Compaq ProLiant 800 | Configuration and Tuning of Sybase System 11 for NetWare o - Page 31
YOther: YYYY Processing Type On-Line Transaction Processing Decision Support Batch Processing Other: Please indicate the type of information you Return to: Database Engineering Compaq Computer Corporation MailCode 090803 20555 SH 249 Houston, Texas 77070 © 1996 Compaq Computer Corporation, All
Configuration and Tuning of Sybase System
11 for NetWare on Compaq Servers
White Paper
________________________________________________________________
Prepared By
Database Engineering
Compaq Computer Corporation
August 1996