Car Solutions QPI-G7-MAIN-V2.0 Przewodnik Instalacji Pobierz pdf (Strona 3)

Important points and caveats

 The configuration described here is exclusively designed for, and is applicable to, sequential data workloads or

limited mixed workloads. Use of this approach on other workload types would need to be tested and may yield

configurations that are effective for other solutions.

 ALL recommendations and best practices defined in the reference architecture guide must be implemented in their

entirety in order to preserve and maintain the sequential order of the data and sequential I/O against the data.

A complete Oracle database DBMS (Database Management System) configuration is a collection of all the

components that are configured to work together to support the database application. This includes the physical

server hardware (with its BIOS settings and appropriate firmware releases), memory, CPU (number, type, clock and

bus speed, cache and core count), operating system settings, the storage arrays and interconnects, disk (capacity,

form factor and spindle speeds), database, DBMS settings and configuration, and even table types, indexing

strategy, and physical data layout.

The primary goal of the HP Scalable Warehouse Solution for Oracle, which is also a common goal when designing

most data center infrastructures, is a balanced configuration where all components can be utilized to their maximum

capability. Architecting and maintaining a balance prevents over subscribing certain components within the stack to a

point where the expected performance is not realized; understanding the performance limits of your configuration can

help prevent wasted cost for components that will never realize their potential due to other constraints within the

stack.

Solution criteria

The HP Scalable Warehouse Solution for Oracle reference configurations are built on the DL980 G7 highly scalable

HP ProLiant server platform, each targeting a different tier of an Oracle Data Warehousing solution. The HP Scalable

Warehouse Solution for Oracle architectures gain greater throughput and scale by using the following approach:

 Targeting query workloads patterned for large sequential data sets rather than small random read/write data

transactions

 Optimizing rapid data reads and query aggregations

This configuration leverages the HP P2000 G3 MSA FC Dual Controller SFF array, which allows for dual reads when

drives are mirrored. For sequential data reads from data warehouse queries, this capability enables tremendous

throughput for the storage system – up to 18,000 MB/sec. The HP Scalable Warehouse Solution for Oracle

approach, and supporting storage array architecture, is optimized for sequential reads. To support a non-optimized,

random I/O data warehousing workload, up to 2 to 3 times the number of drives would be required to achieve the

same throughput. Another approach for random I/O data warehousing is to look at HP High Performance Database

Solution for Oracle or HP Data Accelerator Solution for Oracle.

Tables 1 through 4 below list the supported Intel® Xeon® processors, memory DIMMs, and PCI expansion slots for

the ProLiant DL980 G7 server. This information is included to help determine how the recommended configurations

can be modified to support different workload sizes or user combinations.

Table 1. Supported E7 Family Processors

Processor Type Intel Xeon

Cores per

Processor

Max Cores in a

DL980 G7

E7-4870 (30MB Cache, 2.4GHz, 130W, 6.4 GT/s QPI)

E7-2860 (24MB Cache, 2.26GHz, 130W, 6.4 GT/s QPI)

E7-2850 (24MB Cache, 2.00GHz, 130W, 6.4 GT/s QPI)

E7-2830 (24M Cache, 2.13 GHz, 105W, 6.4 GT/s QPI)

E7-4807 (18M Cache, 1.86GHz, 95W, 4.8 GT/s QPI )

1 2 3 4 5 6 7 8 ... 39 40

Komentarze do niniejszej Instrukcji

Brak uwag

Car Solutions QPI-G7-MAIN-V2.0 Przewodnik Instalacji Strona 3

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Elektronika samochodowa Car Solutions QPI-G7-MAIN-V2.0