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

www.tpc.org/3323

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

View Source

View Source

Additional information: 1 2 3 4 5 6 7

Informações de produto e desempenho

1

É possível que o software e as cargas de trabalho utilizados nos testes de desempenho tenham sido otimizados apenas para desempenho em microprocessadores Intel. Os testes de desempenho como o SYSmark* e o MobileMark são medidos usando-se sistemas de computador, componentes, software, operações e funções específicos. Qualquer modificação em algum desses fatores pode provocar variação nos resultados. Consulte outras informações e outros testes de desempenho para ajudá-lo a avaliar melhor as suas compras, incluindo o desempenho desse produto quando combinado com outros produtos. Para obter mais informações, acesse o site  https://www.intel.com.br/content/www/br/pt/benchmarks/benchmark.html.

2

A Intel não controla nem faz auditoria no design ou na implementação de benchmarks de terceiros ou dos sites da web citados neste documento. A Intel recomenda que todos os seus clientes visitem os sites da web mencionados ou outros onde são apresentadas referências de desempenho semelhantes e confirmem se as referências indicadas são precisas e indicam o desempenho real dos sistemas disponíveis para compra.

3

Os números dos processadores Intel não são indicação de desempenho. Os números dos processadores diferenciam os recursos dentro de uma família de processadores e não de uma família para outra. Consulte www.intel.com/content/www/br/pt/processors/processor-numbers.html para obter mais detalhes.

4

Os compiladores da Intel podem ou não ser otimizados para o mesmo grau de microprocessadores não-Intel no caso de otimizações que não sejam exclusivas para microprocessadores Intel. Essas otimizações incluem os conjuntos de instruções SSE2 e SSE3, além de outras otimizações. A Intel não garante a disponibilidade, funcionalidade ou eficácia de qualquer otimização em microprocessadores não fabricados pela Intel.

Otimizações dependentes do microprocessador neste produto devem ser usadas com microprocessadores Intel. Algumas otimizações não específicas da microarquitetura da Intel® são reservadas para microprocessadores Intel. Para obter mais informações sobre os conjuntos de instruções específicos abordados por este aviso, consulte o guia do usuário do produto e o guia de referência pertinentes.

Revisão do aviso #20110804

5

TPC Benchmark, TPC-C, tpmC, TPC-H, QphH, TPC-E e tpsE são marcas comerciais do Transaction Processing Council. Para obter mais informações, consulte www.tpc.org.

6

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.

7

A frequência ou potência dos processadores Intel® da mesma SKU podem varia, como consequência da variação natural ocorrida no processo de produção.