Cisco Live London 2013Intel and SAP HANA

Bill Horan, Technical Account ManagerIntel Corporation

January 2013

Legal DisclaimersSoftware and workloads used in performance tests may have been optimized for performance only on Intel microprocessors. Performance tests, such as SYSmark and MobileMark, are measured using specific computer systems, components, software, operations and functions. Any change to any of those factors may cause the results to vary. You should consult other information and performance tests to assist you in fully evaluating your contemplated purchases, including the performance of that product when combined with other products.

Intel does not control or audit the design or implementation of third party benchmarks or Web sites referenced in this document. Intel encourages all of its customers to visit the referenced Web sites or others where similar performance benchmarks are reported and confirm whether the referenced benchmarks are accurate and reflect performance of systems available for purchase.

Relative performance is calculated by assigning a baseline value of 1.0 to one benchmark result, and then dividing the actual benchmark result for the baseline platform into each of the specific benchmark results of each of the other platforms, and assigning them a relative performance number that correlates with the performance improvements reported.

SPEC, SPECint, SPECfp, SPECrate. SPECpower, SPECjAppServer, SPECjbb, SPECjvm, SPECWeb, SPECompM, SPECompL, SPEC MPI, SPECjEnterprise* are trademarks of the Standard Performance Evaluation Corporation. See http://www.spec.org for more information. TPC-C, TPC-H, TPC-E are trademarks of the Transaction Processing Council. See http://www.tpc.org for more information.

Intel® Virtualization Technology requires a computer system with an enabled Intel® processor, BIOS, virtual machine monitor (VMM) and, for some uses, certain platform software enabled for it. Functionality, performance or other benefits will vary depending on hardware and software configurations and may require a BIOS update. Software applications may not be compatible with all operating systems. Please check with your application vendor.

Hyper-Threading Technology requires a computer system with a processor supporting HT Technology and an HT Technology-enabled chipset, BIOS and operating system. Performance will vary depending on the specific hardware and software you use. For more information including details on which processors support HT Technology, see here

Intel® Turbo Boost Technology requires a Platform with a processor with Intel Turbo Boost Technology capability. Intel Turbo Boost Technology performance varies depending on hardware, software and overall system configuration. Check with your platform manufacturer on whether your system delivers Intel Turbo Boost Technology. For more information, see http://www.intel.com/technology/turboboost

No computer system can provide absolute security under all conditions. Intel® Trusted Execution Technology (Intel® TXT) requires a computer system with Intel® Virtualization Technology, an Intel TXT-enabled processor, chipset, BIOS, Authenticated Code Modules and an Intel TXT-compatible measured launched environment (MLE). Intel TXT also requires the system to contain a TPM v1.s. For more information, visit http://www.intel.com/technology/security. In addition, Intel TXT requires that the original equipment manufacturer provides TPM functionality, which requires a TPM-supported BIOS. TPM functionality must be initialized and may not be available in all countries.

Intel ® AES-NI requires a computer system with an AES-NI enabled processor, as well as non-Intel software to execute the instructions in the correct sequence. AES-NI is available on Intel® Core™ i5-600 Desktop Processor Series, Intel® Core™ i7-600 Mobile Processor Series, and Intel® Core™ i5-500 Mobile Processor Series. For availability, consult your reseller or system manufacturer. For more information, see http://software.intel.com/en-us/articles/intel-advanced-encryption-standard-instructions-aes-ni/ 

Intel processor numbers are not a measure of performance. Processor numbers differentiate features within each processor series, not across different processor sequences. See http://www.intel.com/products/processor_number for details. Intel products are not intended for use in medical, life saving, life sustaining, critical control or safety systems, or in nuclear facility applications. All dates and products specified are for planning purposes only and are subject to change without notice

Copyright © 2012 Intel Corporation. All rights reserved. Intel, the Intel logo, Xeon and Intel Core are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. All dates and products specified are for planning purposes only and are subject to change without notice

2

Predictable Silicon Track Record

Executing toMOORE’s LAW

Enabling new devices with higher functionality and complexity while controlling power, cost, and size

Intel® Xeon® Processor Historical Performance

Source: Intel internal OLTP database workload performance estimates as of 8 May 2012. Results have been estimated based on internal Intel analysis and are provided for informational purposes only. Any difference in system hardware or software design or configuration may affect actual performance.2005 Xeon 3.66GHz = 64-bit Intel® Xeon® Processor 3.66 GHz, 1M Cache, 667 MHz FSB2005 Xeon 7041 = Intel® Xeon® Processor 7040 (4M Cache, 3.00 GHz, 667 MHz FSB) 2006 Xeon 7100 = Intel® Xeon® Processor 7140M (16M Cache, 3.40 GHz, 800 MHz FSB) 2007 Xeon 7300 = Intel® Xeon® Processor X7350 (8M Cache, 2.93 GHz, 1066 MHz FSB) 2008 Xeon 7400 = Intel® Xeon® Processor X7460 (16M Cache, 2.66 GHz, 1066 MHz FSB) 2010 Xeon 7500 = Intel® Xeon® Processor X7560 (24M Cache, 2.26 GHz, 6.40 GT/s Intel® QPI) 2011 Xeon E7-4800 = Intel® Xeon® Processor E7-4870 (30M Cache, 2.40 GHz, 6.40 GT/s Intel® QPI)

20x Increase in Database Performance since 2005

4

4-socket / MP processor-based serversRelative transactions per given time

Higher is better

Dual Core 90nm

Quad Core 65nm

Eight Core 45nm

Ten Core 32nm

Single Core 90nm

Xeon 7040

Xeon 7500

SixCore 45nm

Xeon 7400Xeon

3.66GHz

Xeon 7300

Dual Core 65nm

Xeon 7100

Xeon E7-4800

SAP HANA on Intel® Xeon® Processor E7 Family Disolves Technology Barriers

SAP HANA

REAL-TIMEBI

Views/Cubes

DB

Latency

Periodic batch upload

BW

Smart Devices

e.g. smart metering, Taxis

User

DB

Latency

Storage Storage

BW Power User

User

• Historical OLTP & OLAP silos• Post purchase Integration• Redundant/Out of time data

BW

Historical Environment

• Simplified landscape (single OLTP & OLAP )• Real-time access to mission critical data• Improved user experience & mobility

HANA SP5

OLTP + OLAP

ERP

ERP

BI

Transactions

Transactions

Latency

OLTP

SAP HANA SP5 combines OLTP and OLAP

OLAP

RDBMS SAP IMDB/HANA

Some data in DRAM or cachemost data on disk* (I/O)

All data in server DRAM

Row format Columnar format (row possible) insert only (main and delta)

Data uncompressed e.g. 20 TB

Data compressed e.g. 10:1~ 2 TB

Aggregates/cubes/views: • to be pre-defined by BW power users• to be calculated• to be stored in DB

Analysis by LoB user on the fly in realtimeNo I/O for read-only queries like OLAP reportsNo pre-computed results

Data gets tranferred over network from DB to APP server for calculations (latency)

Calculation happens on DB server using compressed data

Full table scan on data e.g 2-3 hours * Full table scan on data e.g 2-3 secs (3600 x)*

Seperated DBs for OLTP and OLAP One DB source in server memory IMDB

OLAP gets updated on schedule OLTP and OLAP is always up to date in realtime

Comparision RDBMS vs SAP HANA IMDB

• SAP In-Memory Appliance (SAP HANA™) delivers SAP In-Memory Computing technology through an on going engineering collaboration between SAP and Intel

• Optimized performance and reliability on Intel® Xeon® Processor E7 Family

• Instant access to huge volumes of data

• Lets you model your business in a rapidly changing, competitive environment

• Certified on Cisco UCS Servers C460 M2 and B440 M2

HANA Revolutionizes SAP Decision Making

HANA

9Min.

13Sec.

600

500

400

300

200

100

0Optimized On Disk Query

In-Memory System

Tim

e i

n S

econ

ds

Lower is better

SAP HANA• Appliance offered on Intel® Xeon®

processor 7500 from key OEM’s*• Instant response times to real-time events

“Intel and SAP, through joint engineering, have optimized SAP HANA…enabling greater business agility and innovative usage models that let customers respond to changing conditions in real time.”

- Press Announcement, December 2010Source: SAP HANA Benchmark Study

*Note: E7 family 1.37x faster

8

SAP HANA* & Intel® Xeon® Processor E7 FamilyDramatically Shifting In-Memory Computing

SAP HANA* 1.0 Performance Comparison:Intel® Xeon® Processor E7 Family vs

Intel Xeon Processor 7500 SeriesSAP HANA*Real-time business

insightBetter decisions more

quicklyGreater analytic

flexibilityNear-perfect scaling on

Intel Xeon

processor E7 family

50

500

5000

1 2 4 8

Ru

nn

ing

tim

e (

s)

Socket Count

SAP HANA* ScalabilityCustomer Workload

I deal

8S Glueless

0

50,000

100,000

150,000

200,000

250,000

300,000288,873

210,471

Runnin

g T

ime [m

s]

Running time [ms]

Intel Xeon Processor

7500 Series

Intel Xeon Processor E7 Family

1.37x Faster

Software and workloads used in performance tests may have been optimized for performance only on Intel microprocessors.  Performance tests, such as SYSmark and MobileMark, are measured using specific computer systems, components, software, operations and functions.  Any change to any of those factors may cause the results to vary.  You should consult other information and performance tests to assist you in fully evaluating your contemplated purchases, including the performance of that product when combined with other products.  Source: http://www.intel.com/content/www/us/en/high-performance-computing/high-performance-computing-xeon-e7-analyze-business-as-it-happens-with-sap-hana-software-brief.html

9

Intel® Xeon® Processor E7 FamilyDelivers More Performance, Expandability and RAS

Performance to handle any workload

Expandable & Scalable across processor, memory & I/O

Increased Efficiency through processor & memory energy saving technologies

Data Protection & Reliability to support mission critical applications

CORE 1 CORE 2

CORE 3 CORE 4

CORE 5 CORE 6

CORE 7 CORE 8

CORE 9CORE

10

Xeon E7

CACHE

RAM

UCS C260 M2 UCS C460 M2 UCS B440 M2UCS B230 M2

10

Memory Error RecoveryXeon-EX platform RAS feature for HA in HANA 1.0 production code:

HW patrolling mechanism detects memory failures and allows application to recover from (“early kill”)

Memory MTBF becomes increasingly important with xTB In Memory DB

EX feature, previously seen only in RISC, mainframe, and Itanium-based systems

Application-level recovery unique in industry on Xeon platform

Demos at IDF, ISMC, WSM launch, YouTube,...

Memory-error recovery when app isaccessing corrupted data (“late kill”)

• Challenge: repair data in memory that is in use

• Integrated in HANA 1.5

Memory error recovery demo GUI

11

Advanced Data Protection and Reliability

Secure, Reliable Host for SAP HANA

Performance Leadership

Intel® Xeon® Processor E7 FamilyDelivers More Performance, Expandability and RAS