Installation guide

ManualsBrandsCar Solutions ManualsAutomotiveQPI-G7-MAIN-V2.0

HP recommended configurations for online

transaction processing: ProLiant DL980

G7, VMA-series Memory Array (VMA) and

Oracle 11gR2 database

When your OLTP application needs extreme performance

Technical white paper

Table of contents

Executive summary ............................................................................................................................... 2

Introduction ......................................................................................................................................... 3

Solution criteria ................................................................................................................................... 3

Recommended configurations ................................................................................................................ 7

System/Environment setup .................................................................................................................... 8

Storage configuration details ............................................................................................................. 8

DL980 system setup ........................................................................................................................ 13

Oracle database setup ................................................................................................................... 14

VMA-series Memory Array storage setup .......................................................................................... 15

Test assumptions ............................................................................................................................ 16

Bill of materials .................................................................................................................................. 16

Recommended configuration 1 for 6,000 users ................................................................................. 16

Recommended configuration 2 for 13,000 users ............................................................................... 18

Recommended configuration 3 for 26,000 users ............................................................................... 20

Implementing a proof-of-concept .......................................................................................................... 21

Appendix ......................................................................................................................................... 22

Oracle Advanced Compression ....................................................................................................... 22

For more information .......................................................................................................................... 23

Summary of content (23 pages)

PAGE 1
HP recommended configurations for online transaction processing: ProLiant DL980 G7, VMA-series Memory Array (VMA) and Oracle 11gR2 database When your OLTP application needs extreme performance Technical white paper Table of contents Executive summary............................................................................................................................... 2 Introduction ......................................................................................................................
PAGE 2
Executive summary Always a critical part of the IT infrastructure, databases are at the heart of a number of trends in IT:  Demand for large symmetric multiprocessing (SMP) type scalability in a Linux or Microsoft® Windows® environment  Complex workloads that demand better response times and increased I/O operations per second (IOPS)  Oracle applications and data are growing in size and complexity.
PAGE 3
Introduction The recommended configurations are based on an online transaction processing (OLTP) workload. The set of transactions used in the workload is representative of a web-based application. These transactions allow users to check product availability, place an order for products, pay for their order, view the status of their order, and schedule delivery of their order.
PAGE 4
If you need help with a specific Oracle solution or prefer a solution design or sizing based on your requirements please contact your local HP reseller, HP sales representative, or the HP Oracle Solution Center in your region. Table 1.
PAGE 5
Table 3. Supported Memory DIMMs Memory Kits Rank HP 4GB 1Rx4 PC3-10600R-9 Single HP 4GB PC3L-10600R-9 512Mx Single HP 8GB 2Rx4 PC3-10600R-9 Dual HP 8GB 2Rx4 PC3L-10600R-9, 512Mx RoHS Dual HP 16GB 2Rx4 PC3L-10600R-9 Dual HP 16GB 4Rx4 PC3-8500R-7 Quad PC3L = low voltage memory Table 4 represents the minimum, middle, and maximum memory combinations possible for the 4, 8, and 16 GB memory kits available for the DL980 G7 servers. However, for best performance use dual or quad rank memory DIMMs.
PAGE 6
Note: The PCI-X and PCIe Combination Option slots are not to be used for HP VMA-series Memory Arrays. I/O slots capable of bi-directional x8 PCIe provide the best performance. The DL980 G7 server comes with the Standard Main I/O board with PCIe slots 7-11. Slots 9 and 11 are x8 Gen2 PCIe slots. The PCIe expander option provides additional I/O slots 1-6. Slots 2, 3, 5 and 6 are x8 Gen2 PCIe slots. The low profile expansion option provides additional I/O slots 12-16.
PAGE 7
Recommended configurations The detailed information for these recommended configurations includes the server, number and type of processors, memory, internal and external storage. The configurations were evaluated for a given workload: concurrent users, I/O operations per second, transactions/hour, and database size.
PAGE 8
Figure 1. HP ProLiant DL980 G7 with eight internal drives and an optical DVD System/Environment setup Storage configuration details Internal storage The DL980 G7 OLTP recommended configurations use four internal drives configured with RAID1 for the OS and 11gR2 software. The server supports up to eight internal drives, so additional drives can be added for staging data, logs, or other requirements. Table 8.
PAGE 9
lowest latency speeds for single-server applications. Fibre Channel SAN attach with either blade or rackmount servers allows multiple servers to operate on the same shared data, with practically unlimited amounts of solid state storage. The VMA3210 Memory Array is a 3U appliance that provides solid state storage to servers.
PAGE 10
When the active data of large-scale and high performance applications using Oracle databases is assigned to VMA appliances, dramatic application acceleration and much higher CPU utilization is achieved. This enables the data center by supporting high performance random I/O without the need for large DRAM server footprints or thousands of spinning HDDs. Each VMA3210 is populated with 84 x 128GB solid state memory (SSM) Modules based on Single Layer Cell (SLC) flash memory devices.
PAGE 11
Figure 3 depicts the direct connectivity to the server. Figure 3. Depicts the direct connections between the VMA units and the DL980 server Note: Factory Integration and racking is supported for DL980 servers ordered with VMA-series Memory Array and PCIe-direct options. HP Care Pack Services: Packaged server and storage services for increased uptime, productivity and ROI.
PAGE 12
This reference architecture includes additional conventional storage recommendations for these multiple non-production environments. However, you can substitute an existing SAN solution or add additional VMA arrays to satisfy these non-production requirements. HP P6300 EVA – The HP P6000 Enterprise Virtual Array (EVA) is an enterprise class virtual storage array family for midsized customers at an affordable price.
PAGE 13
Figure 4 shows a sample drive configuration for the P6300 EVA. Figure 4. P6300 EVA logical drive configuration for the additional nonproduction environments DL980 system setup When setting up the DL980 for an Oracle database there are a few best practices that will provide improved performance and proper configuration.  If the DL980 G7 has 1.0TB or more of RAM, the BIOS System Address Mode should be set to 44-bit. By default this is set to 40-bit.
PAGE 14
 Enable the Hardware Prefetcher. The Hardware Prefetcher proactively collects data from the memory to the cache in order to reduce response time. If the application is memory intensive, this enablement may have a negative impact on the performance.  In the BIOS menu under Power Management Options set the HP Power Profile to Maximum Performance.  For environments not running Virtual Machines – Disable Virtualization support in the BIOS as well as INTEL VT-D.
PAGE 15
 We recommend disabling automatic memory management: – SGA_TARGET = 0 – MEMORY_TARGET = 0 (Oracle DB 11g) – MEMORY_MAX_TARGET = 0 (Oracle DB 11g)  Set automatic memory management for the program global area (PGA): – PGA_AGGREGATE_TARGET and WORK_AREA_POLICY set to AUTO VMA-series Memory Array storage setup VMA arrays can be connected directly to existing hardware or can be combined into a hardware refresh or new opportunities.
PAGE 16
Test assumptions  These configurations are examples; there are many additional server/storage options which could also meet the workload requirements.  Testing has not been performed to date on each of these exact configurations. The configurations are based on best practices, benchmarks, extrapolation based on current test knowledge, and performance assumptions through discussions with Oracle and HP experts.
PAGE 17
Table 10. Bill of materials – Configuration 1 – DL980 G7 4P with (2) VMA3210 Memory Arrays Qty Description Production Database Server Configuration 1 HP ProLiant DL980 G7 CTO system 1 HP DL980 G7 E7-2830 FIO 4-processor Kit 4 HP 1200W CS Platinum Power Supply kit 32 HP 8GB 2Rx4 PC3-10600R-9 kit 1 HP Slim 12.7mm SATA DVD Optical kit 1 PCI Express I/O Exp. Kit 2 HP 8Gb Dual Port PCIe FC HBA 1 Dual Port 10GbE Server Adapter 4 HP 72GB 6G SAS 15k 2.
PAGE 18
Recommended configuration 2 for 13,000 users Figure 6. Oracle Database 11gR2 online transaction processing (OLTP) 13,000 user solution Table 11. Bill of materials – Configuration 2 – DL980 G7 4P with (4) VMA3210 Memory Arrays Qty Description Production Database Server Configuration 18 1 HP ProLiant DL980 G7 CTO system 1 HP DL980 G7 E7-4870 FIO 4-processor Kit 4 HP 1200W CS Platinum Power Supply kit 64 HP 8GB 2Rx4 PC3-10600R-9 kit 1 HP Slim 12.7mm SATA DVD Optical kit 1 PCI Express I/O Exp.
PAGE 19
Qty 4 Description HP 72GB 6G SAS 15k 2.5in DP ENT HDD Test/Dev Database Server Configuration 1 HP ProLiant DL980 G7 CTO system 1 HP DL980 G7 E7-2830 FIO 4-processor Kit 4 HP 1200W CS Platinum Power Supply kit 16 HP 8GB 2Rx4 PC3-10600R-9 kit 1 HP Slim 12.7mm SATA DVD Optical kit 1 PCI Express I/O Exp. Kit 2 Dual port 8 Gb FC HBA 1 Dual Port 10GbE Server Adapter 4 HP 72GB 6G SAS 15k 2.
PAGE 20
Recommended configuration 3 for 26,000 users Figure 7. Oracle Database 11gR2 online transaction processing (OLTP) 26,000 user solution Table 12.
PAGE 21
Qty Description 1 PCI Express I/O Exp. Kit 1 Low Profile PCI Express I/O Expansion Kit 2 HP 8Gb Dual Port PCIe FC HBA 1 Dual Port 10GbE Server Adapter 4 HP 72GB 6G SAS 15k 2.5in DP ENT HDD Test/Dev Database Server Configuration 1 HP ProLiant DL980 G7 CTO system 1 HP DL980 G7 E7-2830 FIO 4-processor Kit 4 HP 1200W CS Platinum Power Supply kit 16 HP 8GB 2Rx4 PC3-10600R-9 kit 1 HP Slim 12.7mm SATA DVD Optical kit 1 PCI Express I/O Exp.
PAGE 22
Appendix Oracle Advanced Compression Many customers are looking for solutions that provide a means for reducing the size of their rapidly growing databases without negatively affecting their end user performance. Oracle 11gR2 offers integrated database compression to address this requirement. We often think of compression as being a trade-off between performance and storage: compression reduces the amount of storage required, but the overhead of compressing and decompressing makes things slower.
PAGE 23
For more information For additional Oracle solutions from HP, please visit http://www.hp.com/go/oracle HP VMA-series Memory Array products at www.hp.com/go/VMA; www.hp.com/go/vma-docs HP ProLiant servers, http://www.hp.com/go/proliant HP P6000 Enterprise Virtual Array (EVA), http://www.hp.com/go/eva HP P6300/P6500 Enterprise Virtual Array Best Practice http://h20195.www2.hp.com/V2/GetDocument.aspx?docname=4AA3-2641ENW HP Single Point of Connectivity Knowledge (SPOCK) website http://h20272.www2.hp.