SAP HANA on Intel Xeon Processors: Follow the Leadership Solution—18,000 Customers and Counting

18,000 customers1 are betting on the power of SAP HANA* running on Intel® Xeon® platforms to help their company achieve their digital transformation.

Intel and SAP collaboration

Intel and SAP have been collaborating on engineering, marketing, and sales endeavors since 1997. And Intel began early definition of today’s Intel Xeon processor E7 family system architecture at the same time that SAP started its SAP HANA platform development. After Intel provided the original reference architecture for the SAP HANA platform, the two grew together to make one of the most efficient analytics platforms available today. This collaboration has helped Intel make significant inroads into the mission-critical computing space—leading to improve cost models and configuration flexibility for SAP HANA customers.

Leadership performance, more scalability, and more capabilities with Intel Xeon Processor solutions

The benchmarks validate that the SAP HANA 2 platform shines on Intel Xeon Scalable processors. All SAP BW/4HANA world records are on Intel Xeon Scalable processors and the Intel Xeon processor E7 family.2 Combine that with the Intel Xeon Scalable processor-based offerings for greater scalability:

  • 50 percent more memory support for OLAP and OLTP workloads for the SAP HANA 2 platform compared to the Intel Xeon processor E7 v4 family3
  • 6X more system memory for OLAP to better meet the requirements for high-capacity, massive streaming workloads and 3X more system memory for OLTP workloads for the SAP HANA 2 platform compared to the Intel Xeon processor E7 family3

The added memory support of Intel Xeon Scalable processors-based solutions, enables systems that are certified to natively support up to eight CPUs and up to 1.5 TB of memory capacity per CPU, for a total of up to 12 TB in an eight-CPU configuration. There are plans to certify much larger Intel Xeon Scalable processor-based configurations in the near future. Today, the HPE MC 990x*, based on the Intel Xeon processor E7-v4 family, is certified to scale up to 20 CPU and 20 TB of memory 4. Always check the ‘Certified and Supported SAP HANA® Hardware’ list for the latest information.

That’s just part of the benefit of Intel Xeon Scalable processors. A host of new and enhanced technologies engineered into the processors, such as Intel® Advanced Vector Extensions 512 (Intel® AVX-512) and Intel® Ultra Path Interconnect (Intel® UPI), add to the memory capabilities and new architecture to maximize performance, reliability, availability, serviceability, and manageability.

You can learn more about Intel Xeon Scalable processors and the SAP HANA 2 platform in the “Discover Breakthrough Business Performance” solution brief and the ‘SAP HANA on Intel Xeon Scalable Processors Continue to Shine’ blog.

Choice of deployment options

A variety of OEMs have certified their latest systems for the SAP HANA platform on the Intel Xeon processor Scalable family. In fact, based on the ‘Certified and Supported SAP HANA Hardware Directory’, there are Intel-based SAP HANA offerings including over 1,300 Intel appliances, 37 Intel infrastructure-as-a-service (IaaS) platforms, and 141 Intel entry-level systems.4 These Intel architecture-based options drive a range of choice, differentiation, and a lower total cost of ownership in the SAP HANA ecosystem to best meet customer needs.

We continually hear from customers that they appreciate choice—and choice for a SAP HANA deployment option is no exception. The certified appliance deployment option is only available on Intel-based SAP HANA solutions. Some customers value the benefits of the certified appliance deployment option including: choice of 13 OEMs, easier implementation, support fully provided by SAP, and with safeguarding and solution validation provided jointly by SAP and the OEM. Increasingly, we see customers taking advantage of the Tailored Datacenter Integration or TDI deployment option—enjoying the added flexibility and potential TCO savings along with the ability to use existing hardware. While each deployment option offers unique value, only Intel-based SAP HANA solutions support both the certified appliance and TDI deployment options.

Tailored Data Integration (TDI)—more consolidation and more savings

Let’s drill into TDI a bit more. With the recently introduced TDI phase 5 deployment option, additional potential TCO savings were introduced for SAP HANA customers. SAP HANA TDI phase 5 brings two new important developments for customers. First, increased flexibility and lower TCO have been enabled with the extended support for servers based on Intel Xeon Platinum/Gold/Silver processors and the Intel Xeon E7 v4 family for CPUs having eight or more processor cores. Partners will now be able to build SAP HANA systems using a wide range of CPUs that differ in capability and price. And second, under TDI phase 5, customer workload-driven SAP HANA system sizing now allows customers to fine-tune their system configurations for their specific workload and purchase systems with the optimal number of cores and memory. These innovations can translate into substantial cost savings for SAP HANA customers. See the “TDI Phase 5: New Opportunities for Cost Optimization of SAP HANA Hardware” blog for more on this.

Big increase in memory per core

In some cases, HPE is seeing up to a 3X increase in memory per core on TDI 5 compared to TDI 45. A memory per core increase combined with lower priced CPU options can lead to significant TCO savings on your SAP HANA solution.

Flexibility options for multi-instance/multi-tenant support

Whether a SAP HANA customer chooses an appliance or a TDI deployment, they may be able to achieve further consolidation on SAP HANA platforms by taking advantage of multiple instances or tenants on the same hardware. SAP supports different options for this such as:

  • A combination of MCOS (Multiple Components on One System), MCOD (Multiple Components on One Database), MDC (Multi-tenant DB containers), and hardware partitioning6
  • VMWare vSphere* virtualization7

When consolidating with vSphere on an Intel Xeon processor-based SAP HANA solution, there continues to be a range of capabilities providing multi-tenancy flexibility. For some time now, SAP has supported Intel Xeon processor-based SAP HANA solutions running more than one SAP HANA VM per CPU, the mixing of SAP HANA production and SAP HANA non-production instances, and the mixing of SAP HANA and non-SAP HANA applications on the same server6. In fact, the use of SAP HANA on VMware is quite popular with hosting providers and outsourcers.

What’s coming on Intel-based SAP HANA solutions

There are some exciting continued innovations coming to Intel®-based SAP HANA platforms on the horizon, a new generation of Intel DIMMS that will make memory big, affordable, and persistent. This new generation of Intel persistent memory, based on the groundbreaking 3D XPoint™ media developed by Intel and Micron, will enable data center operators and application developers to overcome a historical barrier to higher application capacity and performance. Intel and SAP have partnered on a persistent memory vision for many years, representing Intel’s commitment to delivering industry innovation and building upon the industry leading solution performance we continue to deliver to end customers today. See the ‘A New Breakthrough in Persistent Memory Gets Its First Public Demo’ blog for more details.

So regardless of which deployment option you choose, be sure to explore your options on your next Intel-based SAP HANA deployment.

Follow me and the growing #TechTim community on Twitter: @TimIntel.

1 Source: SAP HANA + Intel Xeon Scalable Processors = a Winning Combination’ blog- https://blogs.saphana.com/2017/12/07/sap-hana-intel-xeon-scalable-processors-a-winning-combination/.

2 Performance estimates were obtained prior to implementation of recent software patches and firmware updates intended to address exploits referred to as "Spectre" and "Meltdown." Implementation of these updates may make these results inapplicable to your device or system. 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. For more complete information, visit www.intel.com/performance.

SAP* BW on SAP HANA* (runtime of data load/trans) workload: Based on Fujitsu Server Primequest 2800B3*, 8 processors/ 176 cores / 352 threads, Intel® Xeon® Processor E7-8880 v4, 2.20 GHz, 8 KB per core L1 cache and 64 KB L2 cache per core, 55 MB L3 cache per processor, 2048 GB main memory. SuSE Linux Enterprise Server 12* / SAP HANA 1.0 / SAP NetWeaver 7.50*. Certification #: 2018007. Score: Runtime of Data Load/Trans (116,169 secs), Query Executions per Hour (7,239), Runtime of Complex Query (240 seconds). https://www.sap.com/documents/2018/03/fc9e3e0d-f67c-0010-82c7-eda71af511fa.html.

SAP* BW on SAP HANA* (runtime of data load/trans) workload: Based on Fujitsu Server Primequest* 2800B3, 4 processors/ 88 cores / 176 threads, Intel® Xeon® Processor E7-8880 v4, 2.20 GHz, 8 KB per core L1 cache and 64 KB L2 cache per core, 55 MB L3 cache per processor, 1024 GB main memory. SuSE Linux Enterprise Server 12* / SAP HANA 1.0 / SAP NetWeaver 7.50*. Certification #: 2017051. Score: Runtime of Data Load/Trans (56,174 secs), Query Executions per Hour (6,405), Runtime of Complex Query (256 seconds). https://www.sap.com/documents/2017/12/3ae1f126-e57c-0010-82c7-eda71af511fa.html.

SAP* BW on SAP HANA* (runtime of data load/trans) workload: Based on HPE DL560 GEN10*, 4 processors / 112 cores / 224 threads, Intel® Xeon® Platinum 8180 processor, 2.50 GHz, 32 KB L1 cache and 1024 KB L2 cache per core, 38.5 MB L3 cache per processor, 1536 GB main memory. SuSE Linux Enterprise Server 12* / SAP HANA 1.0 / SAP NetWeaver 7.50*. Certification #: 2017048. Score: Runtime of Data Load/Trans (14,575 secs), Query Executions per Hour (6,154), Runtime of Complex Query (186 seconds). https://www.sap.com/documents/2017/11/448ba3b3-de7c-0010-82c7-eda71af511fa.html.

SAP* BW on SAP HANA* (runtime of data load/trans) workload: Based on 1-Node, 4x Intel® Xeon® Platinum 8180 processor (112 cores/224 threads) on DellEMC PowerEdge R940* with 1536 GB total memory on SUSE Linux Enterprise Server 11* using SAP HANA 1.0, SAP NetWeaver 7.50*. Benchmark: SAP BW for SAP HANA @ 1.3B initial records, Source: Certification #: 2017023: https://www.sap.com/documents/2017/07/1cfe642e-c67c-0010-82c7-eda71af511fa.html. Score: Runtime of Data Load/Trans (14,242 secs), Query Executions per Hour (5,561), Runtime of Complex Query (132 seconds). Based on best-published SAP BW on SAP HANA @ 1.3B initial records as of 11 July 2017. 1-Node, 4x Intel® Xeon® E7-8890 v4 processor (96 cores/192 threads) on Dell PowerEdge R930* with 1024 GB total memory on SUSE Linux Enterprise Server 11* using SAP HANA 1.0, SAP NetWeaver 7.50*. Benchmark: SAP BW for SAP HANA @ 1.3B initial records, Source: Certification #: 2016043: https://www.sap.com/documents/2017/11/6cb14bf2-e07c-0010-82c7-eda71af511fa.html. Score: Runtime of Data Load/Trans (21,473 secs), Query Executions per Hour (1972), Runtime of Complex Query (202 seconds).

Intel. “Turn Real-Time Analytics into Real Business Advantage: Leadership Performance.” June 2016. intel.com/content/www/us/en/benchmarks/server/xeon-e7-v4/xeon-e7-v4-world-record.html. For more information, go to intel.com/performance/datacenter and http://global.sap.com/campaigns/benchmark/appbm_bwaml.epx.

Configurations: 4-socket Intel® Xeon® processor E7-8890 v4 family: Dell PowerEdge R930* with four Intel Xeon processors E7-8890 v4, 2.20 GHz (96 cores, 192 threads), 1.5 TB memory, running SUSE Linux Enterprise Server 11*, SAP NetWeaver 7.50*, SAP BW-AML*, SAP HANA* 1.0. Source: SAP certification number 2016025, http://global.sap.com/solutions/benchmark/pdf/Cert16025.pdf. Score: 29,557 advanced query navigation steps/hour; 2 billion records. 4-socket Intel® Xeon® processor E7-8890 v3 family: Dell PowerEdge R930 with four Intel Xeon processors E7-8890 v3, 2.50 GHz (72 cores, 144 threads), 1.5 TB memory, running SUSE Linux Enterprise Server 11, SAP NetWeaver 7.50, SAP BW-AML, SAP HANA 1.0. Source: SAP certification number 2016019, http://global.sap.com/solutions/benchmark/pdf/Cert16019.pdf. Score: 23,690 advanced query navigation steps/hour; 2 billion records. For more information, go to intel.com/performance/datacenter.

3Up to 6x greater system memory supported vs. available solutions from four years ago (representing the currently installed data-center base). SAP has certified its SAP HANA 2* platform for OLAP workloads to support up to 3 TB of memory per system for Intel® Xeon® Scalable processors for a 4-socket configuration (or 6 TB for an 8-socket configuration). Systems available four years ago (representing the typical data center installed base infrastructure) could only support 0.5 TB (or 1 TB in an 8-socket configuration), respectively. For comparative purposes, SAP certifies support for up to 2 TB of memory for the Intel® Xeon® processor E7 v4 family in a 4-socket configuration, so Intel® Xeon® Scalable processor-based systems are certified to support up to 50 percent greater system memory than the generation they replace.

4 Source: ‘Certified and Supported SAP HANA Hardware Directory’ as of March 2018. https://global.sap.com/community/ebook/2014-09-02-hana-hardware/enEN/appliances.html.

5Based on HPE TDI 5 vs. TDI 4 comparison scenario: TDI 5 configuration - 1 HPE DL560 Gen10*, 4s 8C Intel® Xeon® Gold 6134 CPU, 3TB, (MCOS or MDC) at 114,510 estimated compute SAPS. TDI 4 configuration - 1 HPE DL560 Gen10, 4s 28C Intel® Xeon® Platinum 8176, 3TB (MCOS or MDC) at 270,420 estimated compute SAPS. Both TDI 5 and TDI 4 scenarios assume total DB SAPS at 61,000 DB SAPS and 2,833GB SAP HANA* memory – details assumed as follows: CRM server at 10,000 DB SAPs/ 484GB SAP HANA memory, SAP NetWeaver Gateway* at 10,000 DB SAPS/192GB SAP HANA memory, S/4 server at 10,000 DB SAPS/623GB SAP HANA memory, SAP Solution Manager at 11,000 DB SAPS/192GB SAP HANA memory, SAP BW/4HANA* at 20,000 DB SAPS/1,342GB SAP HANA memory.

6SAP note 1788665 - SAP HANA* Support for virtualized / partitioned (multi-tenant) environments (https://launchpad.support.sap.com/#/notes/1788665).

7 Source: SAP HANA* on VMware vSphere*: SAP HANA VMs can get co-deployed with SAP non-production SAP HANA or any other workload VMs, as long as the production SAP HANA VMs are not negatively impacted by the co-deployed VMs. vSphere 6.0 (SAP note 2315348), vSphere 6.5 (SAP note 2393917)- https://wiki.scn.sap.com/wiki/display/VIRTUALIZATION/SAP+HANA+on+VMware+vSphere. And https://www.vmware.com/resources/compatibility/search.php. Note that specific support varies by hardware platform.

Up to 2 production SAP HANA* VMs per socket on vSphere 6.0/6.5 are supported on some Intel® Xeon® E7 v4-based server configurations (up to 8 production SAP HANA VMs on a 4 socket Intel Xeon E7 server, up to 16 production SAP HANA VMs on an 8 socket Intel Xeon E7 server).

Mixing of SAP HANA* production and SAP HANA non-production instances are supported on VMware vSphere 6.0/6.5* on some Intel® Xeon® E7 v4-based servers.

Mixing of SAP HANA* and non-SAP HANA applications are supported on VMware vSphere 6.0/6.5 on some Intel® Xeon® E7 v4-based servers.

Published on Categories Business LeadershipTags ,
Tim Allen

About Tim Allen

Tim is a strategic relationship manager for Intel driving enablement for enterprise software companies related to the cloud, big data, analytics, AEC, commercial VR, datacenter, and IoT. Tim has 20+ years of industry experience including work as a systems analyst, developer, system administrator, enterprise systems trainer, product marketing engineer, and marketing program manager. Prior to Intel Tim worked at IBM, Tektronix, Intersolv, Sequent and Con-Way Logistics. Tim holds a BSEE in computer engineering from BYU and an MBA in finance from the University of Portland. Specialties include - PMP, MCSE, CNA, HP-UX, AIX, Shell, Perl, C++