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

Informazioni su prodotti e prestazioni

1

Il software e i carichi di lavoro utilizzati nei test delle prestazioni possono essere stati ottimizzati per le prestazioni solo su microprocessori Intel®. I test delle prestazioni, come SYSmark e MobileMark, sono calcolati utilizzando specifici sistemi computer, componenti, software, operazioni e funzioni. Qualunque variazione in uno di questi fattori può comportare risultati diversi. Consultare altre fonti di informazione e altri test delle prestazioni per una valutazione completa dei prodotti che si desidera acquistare, comprese le prestazioni di tali prodotti se abbinati ad altri prodotti. Per ulteriori informazioni, visitare il sito Web all'indirizzo www.intel.it/benchmarks.

2

Intel non controlla né verifica la progettazione o l'implementazione di benchmark o siti Web di terze parti citati in questo documento. Intel incoraggia tutti i clienti a visitare i siti Web citati o altri siti in cui vengono segnalati benchmark delle prestazioni simili e verificare se i benchmark citati sono accurati e riflettono le prestazioni dei sistemi da acquistare.

3

I numeri dei processori Intel non corrispondono a una misurazione delle prestazioni, ma sono stati concepiti per differenziare le caratteristiche all'interno di ogni famiglia di processori, e non tra le varie famiglie di processori. Per i dettagli, consultare www.intel.com/content/www/it/it/processors/processor-numbers.html.

4

I compilatori Intel possono o meno garantire lo stesso livello di ottimizzazione per i microprocessori non Intel per quanto riguarda ottimizzazioni non esclusive dei soli microprocessori Intel®. Queste ottimizzazioni includono i set di istruzioni SSE2 e SSE3 e altre ottimizzazioni. Intel non garantisce la disponibilità, la funzionalità o l'efficacia di qualsiasi ottimizzazione su microprocessori non prodotti da Intel.

Le ottimizzazioni dipendenti dai microprocessori in questo prodotto sono pensate per l'uso con microprocessori Intel®. Alcune ottimizzazioni non specifiche per la microarchitettura Intel® sono riservate ai microprocessori Intel. Fare riferimento alle guide dell'utente e alle guide di riferimento dei prodotti applicabili per ulteriori informazioni sugli specifici set di istruzioni a cui si riferisce questo avviso.

Revisione avviso #20110804

5

TPC Benchmark, TPC-C, tpmC, TPC-H, QphH, TPC-E e tpsE sono marchi del Transaction Processing Council. Per ulteriori informazioni, visitare www.tpc.org.

6

SAP e SAP NetWeaver sono marchi registrati di SAP AG in Germania e in molti altri Paesi. Per ulteriori informazioni, consultare www.sap.com/benchmark.

7

I processori Intel® con la stessa SKU potrebbero variare a livello di frequenza o potenza a causa della naturale variabilità del processo di produzione.