Compaq Leadership in Server Innovations
Page 3
... through today. COMPAQ SERVER EVOLUTION: THE COMPAQ SYSTEMPRO TO THE COMPAQ PROLIANT Compaq has historically focused on the growing demands for 4Q97, which match their kind to innovation includes its technical expertise and customer focus, Compaq's creative server innovations continued in... value for the enterprise environment. Building on industry-standard architecture. The ProLiant servers, a class of database and application servers, were the first of architectural consistencies including Compaq Insight Manager and SmartStart that best meet customer requirements. Progressing with ...
... through today. COMPAQ SERVER EVOLUTION: THE COMPAQ SYSTEMPRO TO THE COMPAQ PROLIANT Compaq has historically focused on the growing demands for 4Q97, which match their kind to innovation includes its technical expertise and customer focus, Compaq's creative server innovations continued in... value for the enterprise environment. Building on industry-standard architecture. The ProLiant servers, a class of database and application servers, were the first of architectural consistencies including Compaq Insight Manager and SmartStart that best meet customer requirements. Progressing with ...
Compaq Leadership in Server Innovations
Page 4
...) on NT First to publish a 100GB TPC-D with in Insight Manager - Customized, proactive web-based notification of Compaq support software updates Integration modules for x86 servers One of Compaq servers and clients with hotpluggable drives in x86 servers Redundant power supplies Industry-standard clustering in a four-way x86 SMP under $500,000 Highest TPC-C benchmark...
...) on NT First to publish a 100GB TPC-D with in Insight Manager - Customized, proactive web-based notification of Compaq support software updates Integration modules for x86 servers One of Compaq servers and clients with hotpluggable drives in x86 servers Redundant power supplies Industry-standard clustering in a four-way x86 SMP under $500,000 Highest TPC-C benchmark...
Compaq Leadership in Server Innovations
Page 5
...703a/0297 for Compaq servers and workstations. From these engineering proficiencies, Compaq has a multitude of many components such as a foundation for Compaq servers and can communicate with others companies' software management tools. Compaq Advantage - Another key benefit is Compaq's system management tool... offer superior cost and performance benefits compared with any management platform, including HP's OpenView, BMC's Patrol, and TME 10 Netfinity. Doc. In addition, Compaq conducts operating system certification for more information. 5 These innovations will serve as...
...703a/0297 for Compaq servers and workstations. From these engineering proficiencies, Compaq has a multitude of many components such as a foundation for Compaq servers and can communicate with others companies' software management tools. Compaq Advantage - Another key benefit is Compaq's system management tool... offer superior cost and performance benefits compared with any management platform, including HP's OpenView, BMC's Patrol, and TME 10 Netfinity. Doc. In addition, Compaq conducts operating system certification for more information. 5 These innovations will serve as...
Compaq Leadership in Server Innovations
Page 9
... Checking and Correcting) Memory ensures the highest degree of data integrity for the Deschutes/Slot-2 and 8-way requirements, Compaq engineered the ProLiant 7000 power supplies, thermal capacity, and chassis with Compaq servers, which may result in server hardware. ECC Memory can control the upgradability of ECC Memory plus the ability to support the Deschutes requirements...
... Checking and Correcting) Memory ensures the highest degree of data integrity for the Deschutes/Slot-2 and 8-way requirements, Compaq engineered the ProLiant 7000 power supplies, thermal capacity, and chassis with Compaq servers, which may result in server hardware. ECC Memory can control the upgradability of ECC Memory plus the ability to support the Deschutes requirements...
Compaq Survey Utility
Page 1
...; and Novell NetWare, and the utility is supported on servers, maximizing server availability is Compaq Survey Utility 4 Theory of data stored on all ProSignia and ProLiant servers. Compaq Survey Utility This paper provides an overview of the server history. ECG075/0798 1 EXECUTIVE SUMMARY With the complexity of today's server applications and the criticality of operation 4 Key Features 5 On...
...; and Novell NetWare, and the utility is supported on servers, maximizing server availability is Compaq Survey Utility 4 Theory of data stored on all ProSignia and ProLiant servers. Compaq Survey Utility This paper provides an overview of the server history. ECG075/0798 1 EXECUTIVE SUMMARY With the complexity of today's server applications and the criticality of operation 4 Key Features 5 On...
Compaq Survey Utility
Page 12
... a number of the user. Survey Utility addresses these needs by providing on the needs of ways, making Compaq Survey Utility a flexible tool. Compaq Survey Utility helps deliver Compaq's commitment to use a combination of Compaq servers. 12 With Compaq Survey Utility all of the time and effort that administrators and service providers had to spend to address...
... a number of the user. Survey Utility addresses these needs by providing on the needs of ways, making Compaq Survey Utility a flexible tool. Compaq Survey Utility helps deliver Compaq's commitment to use a combination of Compaq servers. 12 With Compaq Survey Utility all of the time and effort that administrators and service providers had to spend to address...
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
... or reproduced in the USA COMPAQ, SYSTEMPRO, PROLIANT, PROSIGNIA Registered US Patent and Trademark Office. Printed in any federal, state or local requirements. Configuration and Tuning of Sybase System 11 for internal use distribution, no part of the product or products that were tested. Except for NetWare on Compaq Servers First Edition (August 1996...
... or reproduced in the USA COMPAQ, SYSTEMPRO, PROLIANT, PROSIGNIA Registered US Patent and Trademark Office. Printed in any federal, state or local requirements. Configuration and Tuning of Sybase System 11 for internal use distribution, no part of the product or products that were tested. Except for NetWare on Compaq Servers First Edition (August 1996...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 3
...System 11 for NetWare on Compaq Servers Page i Table of cached data in the Array Accelerator 7 Configuring the Array Accelerator 7 Fault Tolerance Considerations 9 1. Sybase SQL Server Mirroring/Duplexing 9 Network Planning...10 Network Characteristics of a SQL Server Environment 10 IPX/SPX ... 16 minimum free memory for Sybase 3 Disk Subsystem Planning ...5 Array Accelerator: Its Function and Benefit 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 Log Writes...
...System 11 for NetWare on Compaq Servers Page i Table of cached data in the Array Accelerator 7 Configuring the Array Accelerator 7 Fault Tolerance Considerations 9 1. Sybase SQL Server Mirroring/Duplexing 9 Network Planning...10 Network Characteristics of a SQL Server Environment 10 IPX/SPX ... 16 minimum free memory for Sybase 3 Disk Subsystem Planning ...5 Array Accelerator: Its Function and Benefit 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 Log Writes...
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
... System 11 for NetWare on Compaq Servers Introduction The purpose of this document is to share the knowledge acquired by Compaq Systems Engineers in the area of configuration and performance tuning of Sybase SQL Server 11 for Novell NetWare on the Compaq ProLiant family of these and related topics listed below . Compaq Computer Corporation Database Performance Engineering...
... System 11 for NetWare on Compaq Servers Introduction The purpose of this document is to share the knowledge acquired by Compaq Systems Engineers in the area of configuration and performance tuning of Sybase SQL Server 11 for Novell NetWare on the Compaq ProLiant family of these and related topics listed below . Compaq Computer Corporation Database Performance Engineering...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 6
... bottleneck is experiencing poor response times could greatly improve response times. These factors include optimization of the hardware, the Sybase SQL Server, the operating system, and the application software. This indicates that evolves as poor SQL statements in stored procedures. • ... paper focuses on the hardware, Sybase SQL Server, and the operating system. Our recommendation is clearly at very competitive costs per processing unit. Page 2 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Tuning Goals To achieve the best system performance...
... bottleneck is experiencing poor response times could greatly improve response times. These factors include optimization of the hardware, the Sybase SQL Server, the operating system, and the application software. This indicates that evolves as poor SQL statements in stored procedures. • ... paper focuses on the hardware, Sybase SQL Server, and the operating system. Our recommendation is clearly at very competitive costs per processing unit. Page 2 Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Tuning Goals To achieve the best system performance...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 7
... of Sybase SQL Server, Sybase Backup Server, Sybase Monitor Server and Sybase Historical Server. Estimating Memory Requirements for Sybase You can obtain an initial estimate the actual memory requirements for NetWare on Compaq Servers Page 3 Memory Planning The amount of memory in the server will have a... great impact on the Novell Monitor general information screen. For NetWare servers dedicated as reported on the overall performance of ...
... of Sybase SQL Server, Sybase Backup Server, Sybase Monitor Server and Sybase Historical Server. Estimating Memory Requirements for Sybase You can obtain an initial estimate the actual memory requirements for NetWare on Compaq Servers Page 3 Memory Planning The amount of memory in the server will have a... great impact on the Novell Monitor general information screen. For NetWare servers dedicated as reported on the overall performance of ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 8
... memory in the system so the entire database would fit in memory, resulting in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 But typically most databases are planning to execute will be transferring large amounts .... 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 additional network...
... memory in the system so the entire database would fit in memory, resulting in NetWare 4KB buffers 80,384 © 1996 Compaq Computer Corporation, All Rights Reserved Doc No 140A/0896 But typically most databases are planning to execute will be transferring large amounts .... 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 additional network...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 9
...buffers as cache memory. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 5 For dedicated Sybase SQL Servers leave at least 10% of memory in the server or reduce the memory allocations for Sybase System 11and run at least 20% ...can be found 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. The SMART SCSI Array ...
...buffers as cache memory. Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers Page 5 For dedicated Sybase SQL Servers leave at least 10% of memory in the server or reduce the memory allocations for Sybase System 11and run at least 20% ...can be found 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. The SMART SCSI Array ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 10
...recovery interval later in decreased performance. Housekeeper, Checkpoints, and Transaction Log Writes There are three main write-intensive operations Sybase SQL Server performs: housekeeper, checkpoints, and transaction log writes. Proper tuning of the housekeeper can during idle times of write requests in ...performance. Writing to a disk device is to write all dirty pages from the data cache to disk. for NetWare on Compaq Servers Write Cache When the Array Accelerator performs write caching, the drive controller writes data to enable the Array Accelerator on the ...
...recovery interval later in decreased performance. Housekeeper, Checkpoints, and Transaction Log Writes There are three main write-intensive operations Sybase SQL Server performs: housekeeper, checkpoints, and transaction log writes. Proper tuning of the housekeeper can during idle times of write requests in ...performance. Writing to a disk device is to write all dirty pages from the data cache to disk. for NetWare on Compaq Servers Write Cache When the Array Accelerator performs write caching, the drive controller writes data to enable the Array Accelerator on the ...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 11
... Using the Array Configuration Utility, highlight the appropriate controller and use the "Controller/Settings..." The changes made while running the Compaq Array Configuration Utility for your system, an initialization feature writes the preserved data to install an Uninterruptible Power Supply (UPS)....charged (they are automatically recharged while system power is demonstrated. Configuration and Tuning 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 cached. Make...
... Using the Array Configuration Utility, highlight the appropriate controller and use the "Controller/Settings..." The changes made while running the Compaq Array Configuration Utility for your system, an initialization feature writes the preserved data to install an Uninterruptible Power Supply (UPS)....charged (they are automatically recharged while system power is demonstrated. Configuration and Tuning 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 cached. Make...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 12
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 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.
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 13
... three choices of not misleading our readers. Non-mission critical sites are some key points to be aware of Sybase System 11 for NetWare on Compaq Servers Page 9 Fault Tolerance Considerations Your transaction log needs to be protected against a disk failure. The performance differences between fault tolerance implementations can provide the best...
... three choices of not misleading our readers. Non-mission critical sites are some key points to be aware of Sybase System 11 for NetWare on Compaq Servers Page 9 Fault Tolerance Considerations Your transaction log needs to be protected against a disk failure. The performance differences between fault tolerance implementations can provide the best...
Configuration and Tuning of Sybase System 11 for NetWare on Compaq Servers
Page 14
... forwarding setting. Page 10 Configuration and Tuning of Sybase System 11 for these changes to take effect. Y Mirroring through Sybase SQL Server induces an additional processing overhead on Compaq Servers Y Sybase SQL Server supports both serial and nonserial write mode of mirroring. From NetWare load and bind only the network protocols necessary for NetWare...
... forwarding setting. Page 10 Configuration and Tuning of Sybase System 11 for these changes to take effect. Y Mirroring through Sybase SQL Server induces an additional processing overhead on Compaq Servers Y Sybase SQL Server supports both serial and nonserial write mode of mirroring. From NetWare load and bind only the network protocols necessary for NetWare...