Amol Bhoite

Hitachi Solution for Databases Reference Architectures for Oracle Real Application Clusters Database 12c using VSP GX00 series and Hitachi Advanced Server DS240/DS220

Blog Post created by Amol Bhoite Employee on Jul 3, 2018

Authors: Libo Jiang, Prabin Bhandari, Amol Bhoite

 

Hitachi Solution for Oracle Real Application Clusters Database 12c is engineered, pre-configured, pre-tested, and qualified to provide predictable performance and the highest reliability in demanding, dynamic Oracle environments. This solution is validated to ensure consistent, predictable results.

Hitachi Solution for Oracle Real Application Clusters Database 12c offer integrated computing options, simplified management and improved utilization that cut total cost of ownership.

This proven solution to optimize your Oracle database environment integrates servers, storage systems, and networks. The environment provides reliability, high availability, scalability, and performance while processing small-scale to large-scale on-line transaction processing (OLTP) and online analytical processing (OLAP) workloads.

This blog describes Oracle Orion and Peakmarks performance results with Hitachi Solution for Databases Reference Architecture for Oracle Real Application Clusters Database 12c

 

This reference architecture provides the following benefits:

  • Predictable, repeatable, reliable results that are pre-validated
  • Faster speed to deploy and increased ability to meet changing needs, with a single source for components and prescriptive guides
  • Extreme reliability of Hitachi Storage
  • Simplified and centralized storage management
  • More effective and efficient use of Oracle Database licensing

Storage Architecture

The following diagram depicts the architecture the DS240, and G900 architecture tested in our solutions engineering lab..

The following diagram depicts the architecture the DS220 and G900 architecture tested in our solutions engineering lab..

The following diagram depicts the architecture the DS220 and G350 architecture tested in our solutions engineering lab..

 

Oracle Orion Test Results

Oracle Orion is a tool for predicting the performance of an Oracle database without having to install Oracle or create a database. Unlike other I/O calibration tools, Oracle Orion is expressly designed for simulating Oracle database I/O workloads using the same I/O software stack as Oracle. Orion can also simulate the effect of striping performed by Oracle Automatic Storage Management.

 

Test Case

Test / Workload type

Metric

2 x DS240 and G900

4 x DS220 and G900

2 x DS220 and G350

1

Storage performance -

100% OLTP Random Read (8k)

Max. IO/s

1,978,638

1,448,845

632,830

Avg. RT

0.94ms

0.98 ms

1.06 ms

2

Storage performance -

100% OLTP Random Writes (8k)

Max. IO/s

331,041

312,350

98,972

Avg. RT

1.2ms

1.15 ms

1.2 ms

3

Storage performance -

100% OLAP Sequential Reads (1024K)

Max. Throughput

23.15 GB/s

22.52 GB/s

 

12.1 GB/s

4

Storage performance -

100% OLAP Sequential Writes (1024K)

Max. Throughput

12.80 GB/s

13.39 GB/s

 

4.7 GB/s

 

Peakmarks Test Results

Peakmarks is the leading benchmark software for Oracle platforms that is used for the following:

§  Performance verification (quality assurance)

§  Evaluation of different infrastructure products, technologies, and solutions (price/performance comparison)

§  Performance optimization (improvement in efficiency)

§  This provides transparency and comparability in price versus performance considerations for Oracle infrastructures.

 

Test case

Test / Workload type

Metric

2 x DS240 and G900

4 x DS220 and G900

2 x DS220 and G350

1

Storage performance random read (STO-RR)

Max. IO/s

857,374

1,006,402

490,500

Avg. RT

1.04 ms

1.01 ms

1.04 ms

2

Storage performance random write (STO-RWF)

Max. IO/s

375,218

378,041

151,062

Avg. RT

0.88 ms

0.44

0.9 ms

3

Storage performance sequential read (STO-SR)

Max. Throughput

22.16 GB/sec

23.32 GB/s 

10.03 GB/s

4

Storage mixed random read write (STO-MIX 20% update ratio)

Max. IO/s

509,325

423,900

220,921

Avg. RT

0.77 ms

0.8 ms

0.9 ms

5

Database medium OLTP select performance - 25 rows per transaction (DBX-S25)

Throughput in transactions per second

41,344

57,090

17,053

Throughput in rows per second

1,033,679

1,427,275

426,331

Avg. RT for SQL statement

12.84 ms

1 ms

7.36 ms

6

Server performance test - OLTP 25 rows per transaction(SRV-S25)

Throughput in transactions per second

20,498

16,878

14,860

Throughput in rows per second

983,892

2,430,470

1,069,953

Throughput in logical buffer reads per second

25,521,434

64,359,458

28,183,253

Avg. RT for SQL statement

0.1 ms

0.1 ms

0.10 ms

7

CPU processor performance test - Arithmetic ADD operation (CP2-SA)

Throughput in operations per second

143,863,438,538

319,117,415,406

98,018,673,985

 

Click here to get Hitachi Solution for Databases Reference Architecture for Oracle Real Application Clusters Database 12c using Hitachi Advanced Server DS240 and VSP G900

Click here to get Hitachi Solution for Databases Reference Architecture for Oracle Real Application Clusters Database 12c using Hitachi Advanced Server DS220 and VSP G900

Click here to get Hitachi Solution for Databases Reference Architecture for Oracle Real Application Clusters Database 12c using Hitachi Advanced Server DS220 and VSP G350

Outcomes