Paper

ManualsBrandsIntel ManualsOtherIntel Xeon Processor E7520

Source: Quoted in “Why In-Memory Computing is Cheaper and Changes Everything,” a Business Analytics blog post by Timo Elliot, SAP Business Objects, 17 April, 2013.

http://timoelliott.com/blog/2013/04/why-in-memory-computing-is-cheaper-and-changes-everything.html

Moore’s Law, rst proposed by Intel co-founder Gordon Moore in 1965, states that the number of transistors on integrated circuits would continue to double every two years.

The economics of silicon-based storage has improved with the growing maturity of ash memory, as embodied by Intel

Solid State Drives. Other non-volatile memory technologies currently in development

also hold considerable promise for the future. Cost versus capacity for these silicon-based storage technologies currently precludes their use as a large-scale replacement for disk-based storage, although

they have considerable value as storage accelerators for data-intensive workloads.

This is true in theory, although it may be some time before the scale and economics of in-memory computing are conducive to hosting all workloads on a single in-memory database.

The Global Information and Technology Report 2012, edited by Soumitra Dutta, Roland Berger Professor of Business and Technology, INSEAD, and Beñat Bilbao-Osorio, Associate Director, Economist,

Centre for Global Competitiveness and Performance, World Economic Forum.

Source: “Real-World Business Cases for SAP HANA: Co-Innovation from Adobe and SAP,” SAP SAPHIRENOW presentation, Orlando, Florida, May 14-16.

http://events.sap.com/sapphirenow/en/session/2364

Source for Yodobashi, Centrica, and T-Mobile examples: The Global Information and Technology Report 2012, edited by Soumitra Dutta, Roland Berger Professor of Business and Technology, INSEAD,

and Beñat Bilbao-Osorio, Associate Director, Economist, Centre for Global Competitiveness and Performance, World Economic Forum. Chapter 1.7, “Harnessing the Power of Big Data in Real Time through

In-Memory Technology and Analytics,” by SAP AG.

Source: Intel internal tests measuring performance for a 10 TB Proof of Performance and Scalability (POPS) workload. Base conguration: Server platform with 4 x Intel

Xeon

processor E7-4870 (10

core, 30 MB Cache, 2.4 GHz, 6.4 GT/s Intel

QPI), BIOS R27 (build date Marche 29, 2011), 1024 GB memory (1067 GHz DDR3 ECC), 73 GB SAS HDD local disk to hold the operating system, IBM Gen3

XIV storage attached via SAN (111 TB total raw space on 132 disks (2TB x 12 disks/pModule x 11 XIV modules), 6 x 16 TB + 1 x 15 TB ext3 le system (only 2 x 16 TB FS were used); SuSe Linux Enterprise

Server v11 SP3 64-bit, IBM DB@ 10.1 FP1 GA (non DPF setup). System under Test: Server platform with 4 x Intel

Xeon

processor E7-4890 v2 (15 core, 37.5 MB Cache, 2.8 GHz, 8.00 GT/s Intel

QPI),

BIOS 44.R01, 1024 GB memory (1333 GHz DDR3 ECC), 300 GB SAS HDD local disk to hold the operating system, IBM Gen3 XIV storage attached via SAN (111 TB total raw space on 132 disks (2TB x 12

disks/pModule x 11 XIV modules), 6 x 16 TB + 1 x 15 TB ext3 le system (only 2 x 16 TB FS were used) ; SuSe Linux Enterprise Server v11 SP3 64-bit, IBM DB2 10.5 FP1 with BLU (DPF not supported at the

time of the test).

Source: Oracle website as of January 17, 2014. http://www.oracle.com/us/corporate/features/database-in-memory-option/index.html

Source: “SQL Server In-Memory OLTP Internals Overview for CTP1,” a SQL Server Technical Article, by Kalen Delaney, June 2013. http://download.microsoft.com/download/F/5/0/F5096A71-3C31-4E9F-

864E-A6D097A64805/SQL_Server_Hekaton_CTP1_White_Paper.pdf

Source: Intel internal measurements November 2013. Congurations: Baseline 1.0x: Intel

E7505 Chipset using four Intel

Xeon

processors E7-4870 (4P/10C/20T, 2.4GHz) with 256GB DDR3-1066

memory scoring 110,061 queries per hour. Source: Intel Technical Report #1347. New Generation 2x: Intel

C606J Chipset using four Intel

Xeon

processors E7-4890 v2 (4P/15C/30T, 2.8GHz) with 512GB

DDR3-1333 (running 2:1 VMSE) memory scoring 218,406 queries per hour. Source: Intel Technical Report #1347.

Source: Intel internal tests measuring performance for a 10 TB Proof of Performance and Scalability (POPS) workload running on IBM DB2 10.1 and IBM DB2 10.5 with BLU Acceleration. Platform

conguration: Server platform with 4 x Intel Xeon processor E7-4870 (10 core, 30MB Cache, 2.4 GHz, 6.4 GT/s Intel

QPI), BIOS R27 (build date Marche 29, 2011), 1024 GB memory (1067 GHz DDR3 ECC),

73 GB SAS HDD local disk to hold the operating system, IBM Gen3 XIV storage attached via SAN (111 TB total raw space on 132 disks (2 TB x 12 disks/pModule x 11 XIV modules), 6 x 16 TB + 1 x 15 TB ext3

le system (only 2 x 16 TB FS were used); SuSe Linux Enterprise Server v11 SP3 64-bit, IBM DB@ 10.1 FP1 GA (non DPF setup and IBM DB2 10.5 FP1 with BLU (DPF not supported at the time of the test).

On a 4-socket natively-connected platform: Intel

Xeon

processor E7 family supports 64DIMMS, max memory per DIMM of 32 GB RDIMM; Intel

Xeon

processor E7 v2 family supports 96DIMMs, max

memory per DIMM of 64 GB RDIMM. This enables a 3x increase in memory.

Up to 4x I/O bandwidth claim based on Intel internal estimates of the Intel

Xeon

processor E7-4890 v2 performance normalized against the improvements over dual-IOH Intel

Xeon

processor

E7-4870 using an Intel internal bandwidth tool running the 1R1W test.

Source for Yodobashi, Centrica, and T-Mobile examples: The Global Information and Technology Report 2012, edited by Soumitra Dutta, Roland Berger Professor of Business and Technology, INSEAD,

and Beñat Bilbao-Osorio, Associate Director, Economist, Centre for Global Competitiveness and Performance, World Economic Forum. Chapter 1.7, “Harnessing the Power of Big Data in Real Time through

In-Memory Technology and Analytics,” by SAP AG.

No computer system can provide absolute reliability, availability or serviceability. Requires an Intel

Run Sure Technology-enabled system, including an enabled Intel processor and enabled technology(ies).

Built-in reliability features available on select Intel

processors may require additional software, hardware, services and/or an Internet connection. Results may vary depending upon conguration. Consult

your system manufacturer for more details.

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

specic 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 information go to www.intel.com/performance.

INFORMATION IN THIS DOCUMENT IS PROVIDED IN CONNECTION WITH INTEL PRODUCTS. NO LICENSE, EXPRESS OR IMPLIED, BY ESTOPPEL OR OTHERWISE, TO ANY INTELLECTUAL

PROPERTY RIGHTS IS GRANTED BY THIS DOCUMENT. EXCEPT AS PROVIDED IN INTEL'S TERMS AND CONDITIONS OF SALE FOR SUCH PRODUCTS, INTEL ASSUMES NO LIABILITY

WHATSOEVER AND INTEL DISCLAIMS ANY EXPRESS OR IMPLIED WARRANTY, RELATING TO SALE AND/OR USE OF INTEL PRODUCTS INCLUDING LIABILITY OR WARRANTIES RELATING

TO FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR INFRINGEMENT OF ANY PATENT, COPYRIGHT OR OTHER INTELLECTUAL PROPERTY RIGHT.

A "MISSION CRITICAL APPLICATION" IS ANY APPLICATION IN WHICH FAILURE OF THE INTEL PRODUCT COULD RESULT, DIRECTLY OR INDIRECTLY, IN PERSONAL INJURY OR

DEATH. SHOULD YOU PURCHASE OR USE INTEL'S PRODUCTS FOR ANY SUCH MISSION CRITICAL APPLICATION, YOU SHALL INDEMNIFY AND HOLD INTEL AND ITS SUBSIDIARIES,

SUBCONTRACTORS AND AFFILIATES, AND THE DIRECTORS, OFFICERS, AND EMPLOYEES OF EACH, HARMLESS AGAINST ALL CLAIMS COSTS, DAMAGES, AND EXPENSES AND

REASONABLE ATTORNEYS' FEES ARISING OUT OF, DIRECTLY OR INDIRECTLY, ANY CLAIM OF PRODUCT LIABILITY, PERSONAL INJURY, OR DEATH ARISING IN ANY WAY OUT OF SUCH

MISSION CRITICAL APPLICATION, WHETHER OR NOT INTEL OR ITS SUBCONTRACTOR WAS NEGLIGENT IN THE DESIGN, MANUFACTURE, OR WARNING OF THE INTEL PRODUCT OR

ANY OF ITS PARTS.

Intel may make changes to specications and product descriptions at any time, without notice. Designers must not rely on the absence or characteristics of any features or instructions marked "reserved"

or "undened". Intel reserves these for future denition and shall have no responsibility whatsoever for conicts or incompatibilities arising from future changes to them. The information here is subject to

change without notice. Do not nalize a design with this information.

The products described in this document may contain design defects or errors known as errata which may cause the product to deviate from published specications. Current characterized errata are

available on request.

Contact your local Intel sales ofce or your distributor to obtain the latest specications and before placing your product order.

Copies of documents which have an order number and are referenced in this document, or other Intel literature, may be obtained by calling 1-800-548-4725, or go to: http://www.intel.com/design/literature.htm

*Other names and brands may be claimed as the property of others. Printed in USA 0214/RS/OCG/XX/PDF Please Recycle 330164-001US

Learn More

Visit the following sites for more information about in-memory computing:

VENDOR SOLUTIONS

• SAP HANA

www.saphana.com/welcome

• IBM DB2 with BLU Acceleration

www-01.ibm.com/software/data/db2/linux-unix-windows/db2-blu-acceleration/

• Oracle Database In-Memory Option

www.oracle.com/us/corporate/features/database-in-memory-option/index.html

• Microsoft SQL Server In-Memory Project (code-named Hekaton)

research.microsoft.com/en-us/news/features/hekaton-122012.aspx

INTEL SERVER PLATFORMS FOR IN-MEMORY COMPUTING

• Intel Xeon Processor E7 v2 Family

www.intel.com/content/www/us/en/processors/xeon/xeon-processor-e7-family.html