Business Intelligence with Intel® Xeon® Processor E7-8800/4800 v4 Product Families
Bring your business’s best ideas to life by transforming big data and real-time analytics into new business opportunities while ensuring the reliability and uptime of the most business-critical services with the Intel® Xeon® processor E7-8800/4800 v4 product families.
Business Intelligence (BI) or decision support contains two primary types of workloads: Data warehousing/data mart tools used to create and run data warehouses and data marts, and data analysis/data mining tools used to access data warehouses for online analytical processing (OLAP), data mining, data visualization, Web query tools, and so on.
Business Analytics with SAP* BW-AML
SAP* BW Advanced Mixed Load (BW-AML) represents typical business warehouse customers looking for near real-time data analysis crucial to timely decision making. Phase 1 measures advanced query navigation steps per hour of large volumes of data. Phase 2 measures the runtimes of single queries and multi-level data load scenarios. Scale factors range from two billion (2B) to 16 billion records. See more at http://sapinsider.wispubs.com/Assets/Articles/2016/April/SPI-Take-SAP-Business-Warehouse-Benchmarking-to-the-Next-Level
Performance measurements as of June 1, 2016. View configuration details ›
Business Intelligence Queries with TPC Benchmark* H
The TPC-H* benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.
The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size), and reflects multiple aspects of the capability of the system to process queries, including the selected database size against which the queries are executed, the query processing power when queries are submitted by a single stream, and the query throughput when queries are submitted by multiple concurrent users. See more at: http://www.tpc.org/tpch/
Performance measurements as of June 1, 2016. View configuration details ›
High-Speed Analytics using STAC-M3* (Shasta Suite) with Kx Systems kdb+*
The STAC-M3* Benchmark is an industry standard benchmark that measures high-speed analytics on time series data, such as tick-by-tick market data (aka "tick database" stacks). This analytical approach is crucial to many trading functions, from algorithm development to risk management. Recent trends like the growth and sophistication of automated trading and the proliferation of new regulations place a premium on technology that can accelerate the analysis of time-series data. The specifications are agnostic to architecture, and the Shasta Suite allows pre-loading of the Kx Systems kdb+ database directly into memory.
Performance measurements as of June 1, 2016. View configuration details ›
Configuration Details for SAP* BW-AML
System Overview |
1-Node, 4x Intel® Xeon® Processor E7-8890 v3 |
1-Node, 4x Intel® Xeon® Processor E7-8890 v4 |
---|---|---|
System Description |
Dell PowerEdge* R930 |
Dell PowerEdge* R930 |
Processor Information |
Intel® Xeon® Processor E7-8890 v3 (2.50 GHz, 45 MB Cache) |
Intel® Xeon® Processor E7-8890 v4 (2.20 GHz, 60 MB Cache) |
Number of Sockets |
4 |
4 |
Number of Cores / Threads |
72 / 144 |
96 / 192 |
Memory Configuration |
1536 GB |
1536 GB |
Operating System |
SUSE Linux Enterprise Server* 11 SP3 |
SUSE Linux Enterprise Server 11 SP4 for SAP Applications |
RDBMS |
SAP HANA* 1.0 |
SAP HANA 1.0 |
Technology Platform Release |
SAP NetWeaver* 7.50 |
SAP NetWeaver 7.50 |
Intel® Hyper-Threading Technology |
Yes |
Yes |
Intel® Turbo Boost Technology 2.0 |
Yes |
Yes |
Benchmark Name |
SAP* BW-AML |
SAP BW-AML |
Phase 1: Number of initial records |
2 billion |
2 billion |
Phase 1: Advanced query navigation steps (Throughput per hour) | 23,690 | 29,557 |
Phase 1: CPU utilization of database server (%) | 90 | 89% |
Phase 2: Normalized mean runtime single query test (seconds/ billion records) | 9.56 | 9.48 |
Phase 2: Total runtime delta load/transformation test (seconds) | 361 | 350 |
Data Source |
www.sap.com/benchmark, certificate #2016019 |
www.sap.com/benchmark, certificate #2016025 |
Configuration Details for TPC Benchmark* H
System Overview |
1-Node, 4x Intel® Xeon® Processor E7-8890 v3 |
1-Node, 4x Intel® Xeon® Processor E7-8890 v4 |
---|---|---|
System Description |
Cisco UCS C460 M4* Server |
HPE ProLiant* DL580 Gen9 Server |
Processor Information |
Intel® Xeon® Processor E7-8890 v3 (2.50 GHz, 45 MB Cache) |
Intel® Xeon® Processor E7-8890 v4 (2.20 GHz, 60 MB Cache) |
Number of Sockets |
4 |
4 |
Number of Cores / Threads |
72 / 144 |
96 / 192 |
Memory Configuration |
3 TB |
3 TB |
Operationg System |
Windows Server* 2012 R2 Standard Edition |
Red Hat Enterprise Linux* 7.2 |
Database Manager | Microsoft SQL Server* 2016 Enterprise Edition | Actian Vector* 5.0 |
Intel® Hyper-Threading Technology |
Yes |
Yes |
Intel® Turbo Boost Technology 2.0 |
Yes |
Yes |
Benchmark Name |
TPC Benchmark* H @ 3000GB |
TPC Benchmark H @ 3000GB |
Performance QphH | 1,071,018.2 QphH@3000GB | 2,140,307.2 QphH@3000GB |
Price/Performance | 0.60 USD/QphH@3000GB | 0.38 USD/QphH@3000GB |
Availability Date |
6/1/2016 |
7/1/2016 |
Data Source |
www.tpc.org/3322 |
Configuration Details for STAC-M3* Benchmark (Shasta Suite)
System Overview |
1-Node, 4 x Intel® Xeon® Processor E7-4890 v2 |
1-Node, 4 x Intel® Xeon® Processor E7-8890 v4 |
---|---|---|
System Description |
Intel White Box (Brickland) |
Lenovo* System x3850 X6 |
Processor Information |
Intel® Xeon® Processor E7-4890 v2 (37.5M Cache, 2.80 GHz) |
Intel® Xeon® Processor E7-8890 v4 (60M Cache, 2.20 GHz) |
Number of Sockets |
4 |
4 |
Number of Cores / Threads per socket |
60 / 120 |
96 / 192 |
Memory Configuration |
6144 GB / 96x 64GB DDR3 RDIMM running at 1066 MT/s) |
6144 GB (96x 64GB DDR4 RDIMM running at 1333 MT/s) |
Operating System |
Red Hat Enterprise Linux* 6.3 kernel 2.6.32-279 ext4 |
Red Hat Enterprise Linux 7.2-kernel 3.10.0-327 6.3 ext4 |
Database |
Kx Systems kdb+ 3.1 |
Kx Systems kdb+ 3.3 |
Intel® Hyper-Threading Technology |
Yes |
Yes |
Intel® Turbo Boost Technology 2.0 |
Yes |
Yes |
Benchmark Name |
STAC-M3* (Shasta Suite) |
STAC-M3 (Shasta Suite) |
STAC-M3 Tick Analytics - Total Elapsed Time |
19428 |
9324 |
100T.VWAB-12D-NO.TIME - Milliseconds (ms) |
4348 |
2223 |
10T.STATS-AGG.TIME - Milliseconds (ms) |
2871 |
1750 |
10T.STATS-UI.TIME - Milliseconds (ms) |
940 |
854 |
10T.THEOPL.TIME - Milliseconds (ms) |
46 |
16 |
10T.VOLCURV.TIME - Milliseconds (ms) |
10253 |
3844 |
1T.MOHIBID.TIME - Milliseconds (ms) |
50 |
20 |
1T.QTRHIBID.TIME - Milliseconds (ms) |
77 |
52 |
1T-STATS-UI.TIME - Milliseconds (ms) |
227 |
166 |
1T.VWAB-D.TIME - Milliseconds (ms) |
22 |
16 |
1T.WKHIBID.TIME - Milliseconds (ms) |
27 |
12 |
1T.YRHIBID-2.TIME - Milliseconds (ms) |
287 |
187 |
1T.YRHIBID.TIME - Milliseconds (ms) |
280 |
184 |
Data Source |
Additional information:1 2 3 4 5 6 7
Product and Performance Information
Benchmark results 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.
Performance varies by use, configuration and other factors. Learn more at www.Intel.com/PerformanceIndex.
Intel does not control or audit the design or implementation of third party benchmarks or websites referenced in this document. Intel encourages all of its customers to visit the referenced websites or others where similar performance benchmarks are reported and confirm whether the referenced benchmarks are accurate and reflect performance of systems available for purchase.
Intel® processor numbers are not a measure of performance. Processor numbers differentiate features within each processor family, not across different processor families. See https://www.intel.com/content/www/us/en/processors/processor-numbers.html for details.
Performance varies by use, configuration and other factors. Learn more at www.Intel.com/PerformanceIndex.
Notice revision #20110804
TPC Benchmark, TPCx-BB, TPC-C, tpmC, TPC-H, QphH, TPC-E, and tpsE are trademarks of the Transaction Processing Council. See www.tpc.org for more information.
SAP and SAP NetWeaver are the registered trademarks of SAP AG in Germany and in several other countries. See www.sap.com/benchmark for more information.
Intel® processors of the same SKU may vary in frequency or power as a result of natural variability in the production process.