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
Информация о продукте и производительности
Результаты эталонных тестов получены до применения недавних пакетов исправлений ПО и обновлений встроенного ПО, предназначенных для устранения уязвимостей под названием «Spectre» и «Meltdown». После установки этих обновлений данные результаты могут быть неприменимы к вашему устройству или системе.
Производительность зависит от вида использования, конфигурации и других факторов. Подробнее: www.Intel.ru/PerformanceIndex.
Корпорация Intel не контролирует и не проводит проверку конструкции или реализации тестов или веб-сайтов других компаний, упомянутых в настоящем документе. Корпорация Intel рекомендует всем своим клиентам посетить указанные веб-сайты или другие сайты с соответствующими данными для подтверждения точности указанных результатов тестирования и определения производительности приобретаемых систем.
Номера процессоров Intel® не являются показателем производительности. Номера процессоров указывают на различия характеристик процессоров в пределах семейства, а не на различия между семействами процессоров. Подробнее см. по адресу: https://www.intel.ru/content/www/ru/ru/processors/processor-numbers.html.
Производительность зависит от вида использования, конфигурации и других факторов. Дополнительная информация — по ссылке: www.Intel.ru/PerformanceIndex.
Редакция уведомления #20110804
TPC Benchmark, TPCx-BB, TPC-C, tpmC, TPC-H, QphH, TPC-E и tpsE являются товарными знаками совета Transaction Processing Council. Дополнительную информацию можно найти по адресу www.tpc.org.
SAP и SAP NetWeaver являются зарегистрированными торговыми марками SAP AG в Германии и в некоторых других странах. Дополнительная информация приведена на сайте www.sap.com/benchmark.
Частота или мощность процессоров Intel® одной модели может отличаться в результате естественных погрешностей в процессе производства.