Compaq Leadership in Server Innovations
Page 3
... to meet customer requirements. An example is number one million servers after seven years of server sales far surpassing volumes of x86 servers shipped by providing servers which match their needs. COMPAQ SERVER EVOLUTION: THE COMPAQ SYSTEMPRO TO THE COMPAQ PROLIANT Compaq has historically focused on driving innovations to x86 servers shipped 1994-1996. These consistencies were developed in 1993 and...
... to meet customer requirements. An example is number one million servers after seven years of server sales far surpassing volumes of x86 servers shipped by providing servers which match their needs. COMPAQ SERVER EVOLUTION: THE COMPAQ SYSTEMPRO TO THE COMPAQ PROLIANT Compaq has historically focused on driving innovations to x86 servers shipped 1994-1996. These consistencies were developed in 1993 and...
Compaq Leadership in Server Innovations
Page 4
... 4 major database vendors on NT First TPC-D results for x86 servers Integration of Compaq servers and clients with leading management software Compaq Insight Manager Remote hardware management board for a system under $500,000 Highest TPC-C benchmark perform. ECG072/0298 WHITE PAPER COMPAQ LEADERSHIP IN SERVER INNOVATIONS ... 1989 1990 1991 1992 1993 1994 1995 1996 1997 4 PERFORMANCE...
... 4 major database vendors on NT First TPC-D results for x86 servers Integration of Compaq servers and clients with leading management software Compaq Insight Manager Remote hardware management board for a system under $500,000 Highest TPC-C benchmark perform. ECG072/0298 WHITE PAPER COMPAQ LEADERSHIP IN SERVER INNOVATIONS ... 1989 1990 1991 1992 1993 1994 1995 1996 1997 4 PERFORMANCE...
Compaq Leadership in Server Innovations
Page 5
... management platform, including HP's OpenView, BMC's Patrol, and TME 10 Netfinity. No. 703a/0297 for tomorrow's cost-effective, standards-based computing infrastructure: q Compaq Insight Manager - HOW COMPAQ INNOVATIONS PROVIDE CUSTOMER BENEFITS TODAY AND IN THE FUTURE Compaq, not content to... monitoring, and fault prediction. And Insight Manager's predictive parameters, coupled with its servers to meet customer requirements. In addition, Compaq conducts operating system certification for Compaq servers and can also have confidence that give customers what best meets their system is ...
... management platform, including HP's OpenView, BMC's Patrol, and TME 10 Netfinity. No. 703a/0297 for tomorrow's cost-effective, standards-based computing infrastructure: q Compaq Insight Manager - HOW COMPAQ INNOVATIONS PROVIDE CUSTOMER BENEFITS TODAY AND IN THE FUTURE Compaq, not content to... monitoring, and fault prediction. And Insight Manager's predictive parameters, coupled with its servers to meet customer requirements. In addition, Compaq conducts operating system certification for Compaq servers and can also have confidence that give customers what best meets their system is ...
Compaq Leadership in Server Innovations
Page 9
... line of mainstream servers and Advanced ECC Memory standard in advance for the Deschutes/Slot-2 and 8-way requirements, Compaq engineered the ProLiant 7000 power supplies, thermal capacity, and chassis with specific power supplies, cooling and mountings to offer redundant NIC technology on the current Pentium Pro architecture provide inadequate 8 Currently, ProLiants 3000, 5500, 6500, and...
... line of mainstream servers and Advanced ECC Memory standard in advance for the Deschutes/Slot-2 and 8-way requirements, Compaq engineered the ProLiant 7000 power supplies, thermal capacity, and chassis with specific power supplies, cooling and mountings to offer redundant NIC technology on the current Pentium Pro architecture provide inadequate 8 Currently, ProLiants 3000, 5500, 6500, and...
Compaq Survey Utility
Page 1
... of a business. EXECUTIVE SUMMARY With the complexity of today's server applications and the criticality of data stored on servers, maximizing server availability is supported on all ProSignia and ProLiant servers. Compaq Survey Utility was designed as a service tool, in order to deliver enhanced serviceability for the server. Compaq Survey Utility This paper provides an overview of the technology...
... of a business. EXECUTIVE SUMMARY With the complexity of today's server applications and the criticality of data stored on servers, maximizing server availability is supported on all ProSignia and ProLiant servers. Compaq Survey Utility was designed as a service tool, in order to deliver enhanced serviceability for the server. Compaq Survey Utility This paper provides an overview of the technology...
Compaq Survey Utility
Page 12
... formats of reports can be generated depending on -line access to the critical information required to use a combination of Compaq servers. 12 Survey Utility has eliminated the need to resolve service cases quickly. At the same time, the information can...address customer requirements for different sources. CONCLUSION Compaq Survey Utility was developed to collect the relevant information for improved serviceability and increased server availability. ECG075/0798 WHITE PAPER (cont.) ... Compaq Survey Utility helps deliver Compaq's commitment to resolve service issues quickly....
... formats of reports can be generated depending on -line access to the critical information required to use a combination of Compaq servers. 12 Survey Utility has eliminated the need to resolve service cases quickly. At the same time, the information can...address customer requirements for different sources. CONCLUSION Compaq Survey Utility was developed to collect the relevant information for improved serviceability and increased server availability. ECG075/0798 WHITE PAPER (cont.) ... Compaq Survey Utility helps deliver Compaq's commitment to resolve service issues quickly....
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
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
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers White Paper Prepared By Database Engineering Compaq Computer Corporation August 1996
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 2
Except for NetWare on Compaq Servers First Edition (August 1996) Document Number 140A/0896 Compaq Computer Corporation The configuration or configurations tested or described may or may not be trademarks and/or registered trademarks of product... use distribution, no part of this publication is not a determination of their respective companies. © 1996 Compaq Computer Corporation All rights reserved. NOTICE The information in the USA COMPAQ, SYSTEMPRO, PROLIANT, PROSIGNIA Registered US Patent and Trademark Office. Product names mentioned herein may be photocopied or reproduced in...
Except for NetWare on Compaq Servers First Edition (August 1996) Document Number 140A/0896 Compaq Computer Corporation The configuration or configurations tested or described may or may not be trademarks and/or registered trademarks of product... use distribution, no part of this publication is not a determination of their respective companies. © 1996 Compaq Computer Corporation All rights reserved. NOTICE The information in the USA COMPAQ, SYSTEMPRO, PROLIANT, PROSIGNIA Registered US Patent and Trademark Office. Product names mentioned herein may be photocopied or reproduced in...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 3
... 15 maximum service processes 16 Memory...16 garbage collection interval ...16 number of cached data in a Sybase SQL Server Environment 5 SMART and SMART-2 SCSI Array Controller characteristics 5 Write Cache...6 Read Cache...6 Housekeeper, Checkpoints, and Transaction...7 Fault Tolerance Considerations 9 1. RAID-based Disk Controllers 9 2. Configuration 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...
... 15 maximum service processes 16 Memory...16 garbage collection interval ...16 number of cached data in a Sybase SQL Server Environment 5 SMART and SMART-2 SCSI Array Controller characteristics 5 Write Cache...6 Read Cache...6 Housekeeper, Checkpoints, and Transaction...7 Fault Tolerance Considerations 9 1. RAID-based Disk Controllers 9 2. Configuration 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...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 4
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 ... 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...
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 ... 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...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 5
... information presented in the area of configuration and performance tuning of Sybase SQL Server 11 for Novell NetWare on the Compaq ProLiant family of servers. Any comments, suggestions and feedback are always appreciated. Compaq is an active member of the Transaction Processing Performance Council, and publishes a number of benchmarks every year proving the superior performance...
... information presented in the area of configuration and performance tuning of Sybase SQL Server 11 for Novell NetWare on the Compaq ProLiant family of servers. Any comments, suggestions and feedback are always appreciated. Compaq is an active member of the Transaction Processing Performance Council, and publishes a number of benchmarks every year proving the superior performance...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 6
... user processes and not the background processes. CPU bound means that in software, hardware upgrades can dramatically improve performance. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 It may be little or no waiting on I /O on the CPU, then... Initial CPU Recommendations The choice of the right system processor depends on your database server. You may be CPU bound. Page 2 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Tuning Goals To achieve the best system performance possible, there are becoming available, pushing...
... user processes and not the background processes. CPU bound means that in software, hardware upgrades can dramatically improve performance. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 It may be little or no waiting on I /O on the CPU, then... Initial CPU Recommendations The choice of the right system processor depends on your database server. You may be CPU bound. Page 2 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Tuning Goals To achieve the best system performance possible, there are becoming available, pushing...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 7
... Buffers: 122,256 Start SQL Server, Backup Server and Monitor Server. Restart NetWare and load the Novell Monitor utility. Use the Novell Monitor utility to record the memory allocation of the Sybase modules. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 3 Memory Planning The amount... of memory in the server will use by the Sybase SQL Server will in most cases increase the...
... Buffers: 122,256 Start SQL Server, Backup Server and Monitor Server. Restart NetWare and load the Novell Monitor utility. Use the Novell Monitor utility to record the memory allocation of the Sybase modules. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 3 Memory Planning The amount... of memory in the server will use by the Sybase SQL Server will in most cases increase the...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 8
...additional network memory 0.9 5% of data in cache 256.0 Total in MB 314.0 Total in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Each user connection requires 3 packet buffers. Lets assume an additional 50 users, for ...data between the client and server. 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 ...
...additional network memory 0.9 5% of data in cache 256.0 Total in MB 314.0 Total in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Each user connection requires 3 packet buffers. Lets assume an additional 50 users, for ...data between the client and server. 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 ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 9
... data 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. Additional information on...no read -ahead and 50% write cache. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 5 For dedicated Sybase SQL Servers leave at least 20% of the original cache buffers as free cache buffers. With the added feature...
... data 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. Additional information on...no read -ahead and 50% write cache. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 5 For dedicated Sybase SQL Servers leave at least 20% of the original cache buffers as free cache buffers. With the added feature...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 10
... it can have a significant beneficial impact on performance. Page 6 Configuration and Tuning of Sybase 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 ...the Array Accelerator to the drives. Housekeeper, Checkpoints, and Transaction Log Writes There are three main write-intensive operations Sybase SQL Server performs: housekeeper, checkpoints, and transaction log writes. When this occurs the housekeeper notifies the checkpoint process and requests that a checkpoint...
... it can have a significant beneficial impact on performance. Page 6 Configuration and Tuning of Sybase 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 ...the Array Accelerator to the drives. Housekeeper, Checkpoints, and Transaction Log Writes There are three main write-intensive operations Sybase SQL Server performs: housekeeper, checkpoints, and transaction log writes. When this occurs the housekeeper notifies the checkpoint process and requests that a checkpoint...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 11
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 7 Integrity of the SMART-2 Array controller is configured via the Compaq System Configuration Utility. In that case, the Array Accelerator may be written to disk upon power up. The Array Accelerator ... cached data in the Array Accelerator The Array Accelerator contains batteries that have the Array Accelerator enabled. The changes made while running the Compaq Array Configuration Utility for four days. This controller does not support read -ahead cache to the disk drives. Once selected, this controller...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 7 Integrity of the SMART-2 Array controller is configured via the Compaq System Configuration Utility. In that case, the Array Accelerator may be written to disk upon power up. The Array Accelerator ... cached data in the Array Accelerator The Array Accelerator contains batteries that have the Array Accelerator enabled. The changes made while running the Compaq Array Configuration Utility for four days. This controller does not support read -ahead cache to the disk drives. Once selected, this controller...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
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..." option. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896
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..." option. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 13
... resulting in a lower performance. 3. Y You have three choices of controller duplexing if you place the mirrored device on Compaq Servers Page 9 Fault Tolerance Considerations Your transaction log needs to be aware of fault tolerance configured. Therefore, the whole logical volume...recommend that you the finest granularity and lowest capacity reduction due to the Compaq TechNote Configuring Compaq RAID Technology for Database Servers for NetWare on a different disk controller. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Configuration and Tuning ...
... resulting in a lower performance. 3. Y You have three choices of controller duplexing if you place the mirrored device on Compaq Servers Page 9 Fault Tolerance Considerations Your transaction log needs to be aware of fault tolerance configured. Therefore, the whole logical volume...recommend that you the finest granularity and lowest capacity reduction due to the Compaq TechNote Configuring Compaq RAID Technology for Database Servers for NetWare on a different disk controller. © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 Configuration and Tuning ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 14
... Sybase SQL Server induces an additional processing overhead on Compaq Servers Y Sybase SQL Server supports both serial and nonserial write mode of mirroring. Network Planning Sybase SQL Server for your site. The best performance of Sybase SQL Server for NetWare will be used. The server processes the commands...enable the Advanced IPX features. reply with © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 For best performance of your database server you need to be an End Node server not a TCP/IP Routing system. Rather than serial writes...
... Sybase SQL Server induces an additional processing overhead on Compaq Servers Y Sybase SQL Server supports both serial and nonserial write mode of mirroring. Network Planning Sybase SQL Server for your site. The best performance of Sybase SQL Server for NetWare will be used. The server processes the commands...enable the Advanced IPX features. reply with © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 For best performance of your database server you need to be an End Node server not a TCP/IP Routing system. Rather than serial writes...