ibm power systems and ibm flashsystem flash storage ... · poc performance test with jd edwards...

© 2014 IBM Corporation IBM Oracle ICC

IBM Power Systems and IBM FlashSystem Flash Storage Performance for Oracle Applications

Patrick MooreSolution Sales [email protected], 2014

Oracle Alliance TeamInternational Competency Center

Oracle Alliance Team International Competency Center

mailto:[email protected]

IBM Oracle ICC2 © 2014 IBM Corporation

Agenda

IBM FlashSystem flash storage introduction

IBM Power Systems and FlashStorage Proof of Concept Performance Tests


IBM FlashSystem Portfolio

Extreme Performance

Macro EfficiencyMicroLatency™ Enterprise Reliability

Extreme Performance

IBM FlashSystem Solution

IBM FlashSystem 840IBM FlashSystem 820San Volume Controller (SVC)

IBM FlashSystem 840IBM FlashSystem 820 IBM FlashSystem 720IBM FlashSystem 810 IBM FlashSystem 710

Enterprise Features

• Boost enterprise productivity

• Improve application performance

• Ideal for OLTP, data warehousing and OLAP environments

• High availability system

• Acceleration of applications

• Enterprise feature sets to ensure data protection

Boost performance/efficiency without re-architecting applications or the storage infrastructure

Presenter

Presentation Notes

There is a need for extreme raw performance of low latency, IOPS and bandwidth


Oracle Acceleration with IBM FlashSystemCustomer Challenge – Most Oracle applications are highly read-intensive. As such, additional processing power alone does little or nothing to improve performance. By placing all read data on low latency flash storage, reads will be performed much faster, boosting Oracle performance by up to 12x over conventional disk systems with no tuning or changes to code or system architecture.

IBM FlashSystem shared flash storage systems will►Decrease I/O wait time in mission critical Oracle

workloads ►Deliver the lowest latency available on any SAN

platform►Accelerate commonly I/O-bound workloads,

including transactional, batch and complex analytics

Delivers Extreme Performance, Macro

Efficiency, and Enterprise Reliability for


IBM Power Systems and FlashStorage Proof of Concept Performance Tests

PoC study 1 - Oracle’s JD Edwards EnterpriseOne on a Power 780 server with AIX and FlashSystem 820 flash storage

PoC study 2 - Oracle E-Business Suite on a Power 780 server with AIX and FlashSystem 820 flash storage


PoC Performance Test with JD Edwards EnterpriseOne - Background

Large medical manufacturing company

JD Edwards EnterpriseOne 9.0.2 applications with 8.98.3.3 tools

Using financials, distribution, and manufacturing suites

Worldwide operation running up to 950 users and a heavy batch workload

Lengthy, complex nightly batch process (primarily MRP) to plan the manufacture of medical equipment

Client challenge –

► Need to reduce elapsed processing time required for nightly batch

► Nightly batch jobs taking 8-12 hours to complete

► Batch overrun into daily interactive user ramp-up

► Dedicated system for batch runs needed for up to five hours


Current Environment

Power 795 server with 32 cores (POWER7) with 1 TB memory with AIX 6.1

SAN Volume Controller with 32 GB memory and 4 x 146GB SSDs

DS8300 storage system with approximately 8 TB of disk storage

*Note: Other than the logical partition running the database, core counts are approximate as the system is configured to run uncapped and dynamically move processing resource between the partitions as needed.

LPAR Cores* Memory GB Notes

Database 12 400 Oracle Database 11.1 (8 TB)

Applications 3 64 EnterpriseOne 9.0.2 with Tools 8.98.3.3 (900 users)

User Batch 2 32 EnterpriseOne 9.02 with Tools 8.98.3.3

Scheduled Batch 8 32 EnterpriseOne 9.02 with Tools 8.98.3.3

Web Servers (4) 1 24 Oracle Application Server 10.2 with Java™ 1.5 (32-bit)

Euro Apps 1 4 EnterpriseOne 9.0.2 with Tools 8.98.3.3 (50 users)

Euro User Batch 1 16 EnterpriseOne 9.0.2 with Tools 8.98.3.3

Euro Sched Batch 1 8 EnterpriseOne 9.0.2 with Tools 8.98.3.3

Scheduler 1 32 Cisco


PoC Performance Test Environment

LPAR Cores Memory GB Notes

Database 12 400 Oracle Database 11.2.0.3.4 (8 TB)

Applications 3 32 EnterpriseOne 9.0.2 with Tools 8.98.4.11

User Batch 3 32 EnterpriseOne 9.0.2 with Tools 8.98.4.11

Scheduled Batch

3 64 EnterpriseOne 9.0.2 with Tools 8.98.4.11

Web Servers (4)

1 12 Oracle Application Server 10.2

Scheduler 1 32 Cisco

VIOS (2) 0.4 16 PowerVM 2.2.2 SP1

*To run the JD Edwards EnterpriseOne test workload, only a portion of the system was used

SAN Volume Controller with 32 GB memory and 4 x 146GB SSDs DS8300

storage system with ~8 TB of disk storage

Power 780 server with 64 cores (POWER7+) with 2 TB memory* with AIX 6.1

FlashSystem 820 with 20 TB of flash storage


PoC Performance Test Workload

Nightly batch cycle consisting of 712 distinct jobs:►154 critical batch jobs including the MRP process

►134 non-critical JD Edwards EnterpriseOne batch jobs

►424 jobs pulling data from JD Edwards EnterpriseOne tables to populate a data warehouse

Also ran a single user test of the Sales Order Entry application using the Configurator function to determine interactive performance improvements, this was a subjective assessment


PoC Performance Test Results

0

1000

2000

3000

4000

5000

6000

7000

8000Ti

me

in m

inut

es

Baseline 780 + 820 tuned run

Baseline 7239 4171 1911 1156780 + 820 tuned run 5202 2993 1405 803

All Batch Critical batch Non-critical batch Data Warehouse jobs

Critical batch job processing (MRP process) run time reduced by 28%

Single user test of the Sales Order Entry application using the Configurator function determined interactive performance ran faster and was more responsive


PoC Performance Test with Oracle E-Business Suite - Background Large wholesale grocery supply company

Growing regional wholesale supplier using Oracle E-Business Suite to process critical nightly order volumes

Plans for major growth by acquisition and concern over increased order volumes

Oracle E-Business Suite 12.1

Client challenge –

► Plan for greatly increased order volumes, primarily EDI

► Design a computing platform to handle these increased volumes

► Meet all service level agreements for order processing and delivery


Current Environment

Configuration:►Two Oracle Database 11g R1 with RAC LPARs for the Oracle E-Business Suite

database with 10 processor cores for each LPAR

►Oracle E-Business Suite 12.1

►Oracle Database 11.1.0.7

Power 795 server with POWER7 processors and AIX 6.1

SAN Volume Controller

DS8000 storage system


PoC Performance Test Environment

Configuration:– Two Oracle Database 11g R2 with RAC LPARs for the Oracle E-Business Suite

database with 16 processor cores for one LPAR and 4 cores for the other LPAR– Oracle E-Business Suite 12.1– Oracle Database 11.2.0.3.5

SAN Volume Controller

DS8000 storage system

Power 780 server POWER7+ processors and AIX 6.1

FlashSystem 820 flash storage


PoC Performance Test Workload

The client uses Oracle E-Business Suite 12.1 applications to process their nightly order volumes. The cumulative order processing workflow consists of a number of job steps, those jobs are: ►High Volume Order Import►Pre Processor Wrapper Program

►Soft Check Wrapper Program

►Pre Allocation Wrapper Routing Program

►Regular Order Allocation Processor►Order Management Release to Warehouse Management System Wrapper

Program

►Post Release Wrapper Routing Program

The critical individual job steps for this client were the “High Volume Order Import” and “Regular Order Allocation Processor” jobs (in bold above)

The client was also interested in the “gather schema statistics” process performance for their production Oracle Database


PoC Performance Test Results – 1 Day Order Volumes

“High Volume Order Import” job step ran 4 times faster in the PoC environment

“Regular Order Allocation Processor” job step ran more than 2 times faster in the PoC environment

30k Order Line (1 day volume) Test Results

0:06:27

0:01:32

0:12:21

0:05:17

0:00:00

0:01:26

0:02:53

0:04:19

0:05:46

0:07:12

0:08:38

0:10:05

0:11:31

0:12:58

0:14:24

Current Production PoC (Power 780 and FlashSystem 820)

E n v i r o n m e n t

R u

n t

i m e

(h:m

m:s

s)

High Volume Order Import Regular Order Allocation Processor


PoC Performance Test Results – 10 Day Order Volumes

The Cumulative Order Processing job stream (all jobs) ran more than 2 times faster in the PoC environment

In the PoC environment 10 times the order volume was processed in only about 4 times the required run time demonstrating excellent scalability

Cumulative Order Processing

0:24:45

0:11:03

0:49:57

0:00:00

0:07:12

0:14:24

0:21:36

0:28:48

0:36:00

0:43:12

0:50:24

0:57:36

Current Production -1 day PoC (Power 780 and FlashSystem 820)- 1 day test

PoC (Power 780 and FlashSystem 820)- 10 day test


R u

n t

i m e

(h:m

m:s

s)


PoC Performance Test Results – Gather Schema Statistics

The Gather Schema Statistics histogram collection job ran 6 times faster in the PoC environment

Gather Schema Statistics

6:35:00

1:06:000:00:00

1:12:00

2:24:00

3:36:00

4:48:00

6:00:00

7:12:00

Current Production PoC (Power 780 and FlashSystem 820)


R u

n t

i m e

(h:m

m:s

s)


Summary

IBM FlashSystem flash storage in combination with IBM Power Systems servers deliver significant performance benefits for real-world Oracle workloads

►Improving critical JD Edwards EnterpriseOne batch job (MRP process) run time by 28%

►Improving JD Edwards EnterpriseOne Sales Order Entry with Configurator interactive performance, making it run faster and be more responsive

►Helping the Oracle E-Business Suite “High Volume Order Import” job step run 4 times faster and “Regular Order Allocation Processor” job step run more than 2 times faster

►Boosting the Oracle Database Gather Schema Statistics histogram collection job to run 6 times faster


Resources

Performance benefits of IBM Power Systems and IBM FlashSystem for JD Edwards EnterpriseOne white paper:

► www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102335

Performance benefits of IBM Power Systems and IBM FlashSystem for Oracle E-Business Suite white paper:


Performance benefits of IBM Power Systems and IBM FlashSystem for JD Edwards EnterpriseOne white paper:


Performance benefits of IBM Power Systems and IBM FlashSystem for Oracle E-Business Suite white paper:


http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102335




ibm power systems and ibm flashsystem flash storage ... · poc performance test with jd edwards...

Documents