sap hana on ibm power8 june 2016 chr. hansen · pdf filesap hana on ibm power8 june 2016 chr....

SAP HANA on IBM POWER8June 2016

Chr. Hansen

Stefan Falkensteen

IBM Nordic

POWER BUE

© 2014, 2015 International Business Machines Corporation

from Top Ribbon under

The dashed borders

around the logo graphics are

not visible in Show view or

1. Shift + click on the

2. Click on ‘Load

customized ribbon tab

4. Use Image Tools to pan,

Chr. Hansen A/S

SAP HANA on BW running POWER

Peter Berning, Infrastructure Mgr.

2


1. Insert header


4. Click on ‘Increase Indent’

The dashed borders




2. Click on ‘Load



Chr. Hansen in brief

Founded in 1874 in Copenhagen by Danish

pharmacist Christian D.A. Hansen

Listed on NASDAQ OMX Copenhagen

2014/15 turnover EUR 859 million

Organic growth ambitions of 7-10% annually

2,600 employees


1. Insert header


4. Click on ‘Increase Indent’

The dashed borders




2. Click on ‘Load



Today we areA global supplier of bioscience based

ingredients to the food, health,

pharmaceutical and agricultural industries

We mainly produce cultures and dairy

enzymes, probiotics and natural colors

Our leading market positions stem from

innovative products and production

processes, long-term customer relationships

and intellectual property

Chr. Hansen Process Operator


Why SAP HANA on BW

Our current BW was running out of space and no expansion

possibility existed within the BW application.

Only possible solution was to migrate to SAP HANA.

Approach

Internally startup a SAP HANA Platform Evaluation discussion

Conduct PoC of selected solution

OS Version = Linux Suse 11

HANA version = Hana sps 9

Evaluate result

Start a Tender


Platform Scenarios

Both scenarios must run on HANA certified hardware and OS.


Evaluation Scenarios

HANA DB

TDI

Power Intel

TDIAppliance Appliance

Scenario CH Context

TDI Power Valid scenario.

Appliance Intel Valid scenario.

TDI Intel Scenario technical valid, but not considered mature

in a CH context.

Appliance Power SAP HANA on Power will not be delivered as an

appliance solution. This scenario will not be

evaluated.


SAP HANA on BW Evaluation

Intel Appliance Intel TDI Power 8 TDI

Implementation 5 2 4

Investment

Lock-in

Resources

Mainstream

Agility

References 5 3 1

With rating

5 Best – 1 Worst


SAP BW on Hana installation / Spec

The TDI solution for SAP BW on Hana was preferred

We required a 4 system landscape environment (Development, QA,

Production and a Sandbox system) in order to insure stability.

Following the guideline of the sizing / tool and in order to foresee future

growth … (Scalability is important !!)

Current DB size of BI is 3.1TB, (compressed BI SAP 300GB)

DR must be a part of the solution.


SAP BW on Hana POC findings

The following results are measured “out of the box” on the HANA

PoC system where only the mandatory post-migration steps are

completed.

Post migration optimization and in some cases remodeling is

necessary to reap the full benefits so the results should only be

considered preliminary.

PoC ahead of time plan.


Load of Profit Center Accounting data

Most BW loads are executing at night where load time is not so

critical as long as data is available in the morning.

Some chains like Profit Center Accounting for previous period is,

however, often run additional times during working hours as part of

the time sensitive monthly closing process where reduced runtime

would be beneficial.

Total runtime (seconds)

Test Case Today

HANA PoC

“Out of the

box”

Improvement

1 PCA Previous Period 2400 600 75%


Query Performance

Most queries today utilize the BW Accelerator and are therefore not

expected to improve significantly with HANA

Queries directly on line item tables should improve significantly,

especially on the data extraction step

Total runtime (seconds) Data Extraction Step (seconds)

Test CaseUtilizing BW

acceleratorToday

HANA PoC

“Out of the

box”

Improvement Today

HANA PoC

“Out of the

box”

Improvement

1 Line item report No 256 90 65% 177 28 84%

2 Query Accelerated today Yes 45 25 44% 26 10 62%

3 Query with complex calculations Yes 99 90 9% 1,8 1,9 -6%

4 Query not optimized today Yes 257 62 76% 252 56 78%


Hardware location and setup

All hardware running SAP are located in Hoersholm,

Denmark.

Our hardware are located in two buildings, Datacenters I

and Datacenter II,

Enterprise servers

The Production servers are located in Datacenter I and are

divided into 4 LPAR’s

The Development / QA /SBX server is located in Datacenter

II and are divided into 4 LPAR’s

Scale out servers / HANA

The production server located in Datacenter I

The development/QA/ SBX / and failover server are located

in Datacenter II


POWER i Enterprise setup

LPAR 1, DKCH10

SAP system: ECP, EJP, GWP

1,5 core

30 GB Memory

1 TB disk

LPAR 2, DKCH11

Sap systems: CHP, HRP, APP

7 core

256 GB memory

15 TB disk

LPAR 3, DKCH12

SAP system: SMP

1 core

12 GB memory

3 TB disk

LPAR 4, DKCH30

SAP System: NWP, BJP, NWI

4 core

165 GB memory

13 TB disk

Estimated: Power consumption: 5.500 Watts

Cooling: 19.000 BTU/hour

Power System model 770

13/24 cores POWER7+ 4,22 GHz

512/512 GB main storage

SAS disk: 12.6 TB

SSD: 2,4 TB

OS: IMB I 7.2

Production Environment


POWER i Enterprise setup

LPAR 1, DKCH21

SAP system: CHD, APD, NWD,

BJD, HRD, ECD, EJD, GWD

5 core

190 GB Memory

8,7 TB disk

LPAR 2, DKCH22

Sap systems: CHQ, HRQ, APQ

5 core

134 GB memory

8,7 TB disk

LPAR 3, DKCH23

SAP system: Remote journal ,

CHU

1 core

24 GB memory

10,7 TB disk

LPAR 4, DKCHV24

SAP System: CHS, APS,NWS,

BJS, HRS, ECS, EJS, GWS

3 core

139 GB memory

21,9 TB disk






SAS disk:

SSD:

OS: IMB I 7.2

Production Environment






SAS disk: 50 TB

OS: IBM I 7.2

Development/QA

Environments


SAP HANA on BW setup

Power E85032 core 3,72 GHz POWER81.024 GB memory122.000 SAPS (ECC 6.0 / SLES 11)

Power E85032 core 3,72 GHz POWER81.024 GB memory122.000 SAPS (ECC 6.0 / SLES 11)

Power S824L24 core 3,52 GHz POWER81.024 GB memory96.000 SAPS (ECC 6.0 / SLES 11)


SAP Landscape setup

Development within the SAP

environment is performed, following

best practice, using a 4 system

landscape setup.

Development

QA

Production

Sand box

S-Box DEV QA PRD

Changes – Customizing

Prototypes & Notes

No transports from S-Box to DEV


CH SAP system landscape

CHD CHQ CHP CHS

APD APQ APP APS

NWD NWQ NWP NWS

BJD BJQ BJP BJS

ECD ECQ ECP

NW BI 7.4Abap stack / NetWeaver

SCM 7.02 / Supply Chain Management

ECC 6.07 / ERP Central Component

WCEM = Web Channel Experience Management. User store Ecommerce

NW BI 7.4Java stack

HRD HRQ HRP HRS ECC 6.07

EJD EJQ EJP

Fiori 7.4 / device agnostic user interface

ECS

EJS

GWD GWQ GWP GWS

WCEM

Ecommerce


2. Click on ‘Load



probiotic tablets

We have been running SAP on this

hardware platform since 1998

Now with 2600 named users

30 locations

5 Continents

21 countries running SAP, 24/7 all

year round

We have now been running for 17

years – without one single unplanned

system shutdown since 1998

KNOCK ON WOOD !!!

The Fact’s


2. Click on ‘Load



22

Find & follow

www.chr-hansen.com

www.chr-hansen.com/youtube

www.chr-hansen.com/linkedin

www.chr-hansen.com/twitter

sap hana on ibm power8 june 2016 chr. hansen · pdf filesap hana on ibm power8 june 2016 chr....

Documents