Business Intelligence with Intel® Xeon® Processor E5-2600 v4 Product Family
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 E5-2600 v4 product family.
Business intelligence (BI) or decision support, contains two primary types of workloads: Data warehousing and data mart tools used to create and run data warehouses and data marts, and data analysis and data mining tools used to access data warehouses for online analytical processing (OLAP), data mining, data visualization, web query tools, and so on.
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 March 16, 2016. Configuration Details >
Big Data Analytics Systems with TPCx-BigBench (TPCx-BB)
The TPC Benchmark* Express-BigBench (TPCx-BB) measures the performance of end-to-end big data analytics by implementing 30 use cases that simulate big data processing, big data analytics, and reporting. The data represented are either structured, semi-structured, or un-structured data types. These use cases are frequently performed by big data operations at retailers with both physical and online store presence.
The TPCx-BB performance metric is called the Big Bench Query-per-minute (BBQpm@Size), where size is the scale factor of the data. The metric reflects three test phases: a load test that aggregates data from various sources and formats; a power test that runs each use case once to identify optimization areas and utilization patterns; and a throughput test that runs multiple jobs in parallel to test the efficiency of the cluster. TPCx-BB is implemented to work with modern big data analytics frameworks residing in the Hadoop ecosystem such as Map Reduce, Hive, Spark, Tez, and MLLIB. See more at: http://www.tpc.org/tpcx-bb/.
Performance Measurements as of March 16, 2016. Configuration Details. >
Business Intelligence Queries with TPC Benchmark* H
System Overview |
1-Node, 2x Intel® Xeon® Processor E5-2690 v2 | 1-Node, 2x Intel® Xeon® Processor E5-2699 v3 | 1-Node, 2x Intel® Xeon® Processor E5-2699 v4 |
---|---|---|---|
System Description |
Cisco UCS* C240 M3 Server | HPE ProLiant* DL380 Gen9 | HPE ProLiant* DL380 Gen9 |
Processor Information |
Intel® Xeon® processor E5-2690 v2 (3 GHz, 25MB cache, 130W) |
Intel® Xeon® processor E5-2699 v3 (2.30 GHz, 45MB cache, 145W) |
Intel® Xeon® processor E5-2699 v4 (2.20 GHz, 55MB cache, 145W) |
Number of Sockets |
2 | 2 | 2 |
Total Number of Cores / Threads |
20 / 40 | 36 / 72 |
44 / 88 |
Memory Configuration |
24x 32GB DDR3-1866-MHz LRDIMM/PC3-14900 |
24x 32GB Quad Rank x4 DDR4-2133 CAS-15-15-15 Load reduced |
24x 32GB 2Rx4 PC4-2400T-L |
Operating System |
Microsoft SQL Server 2014 Enterprise Edition |
Microsoft Windows Server 2012 R2 Standard Edition | Microsoft Windows Server 2012 R2 Standard Edition |
Database Manager | Microsoft Windows Server 2012 Standard Edition | Microsoft SQL Server 2016 Enterprise Edition | Microsoft SQL Server 2016 Enterprise Edition |
Intel® Hyper-Threading Technology | Yes | Yes | Yes |
Intel® Turbo Boost Technology 2.0 | Yes | Yes | Yes |
Benchmark Name | TPC Benchmark H @ 1000GB |
TPC Benchmark H @ 1000GB |
TPC Benchmark H @ 1000GB |
Performance QphH | 304,361 QphH@1000GB | 543,102 QphH@1000GB | 678,492.3 QphH@1000GB |
Price/Performance | .73 USD per QphH@1000GB | .69 USD per QphH@1000GB | .60 USD per QphH@1000GB |
Availability Date | 08/20/14 | 07/31/2016 | 07/31/2016 |
Data Source | http://www.tpc.org/3301 | http://www.tpc.org/3318 | http://www.tpc.org/3320 |
Big Data Analytics Systems with TPC Benchmark* Express-BigBench (TPCx-BB)
System Overview |
9-Nodes, 2x Intel® Xeon® Processor E5-2697 v3 |
9-Nodes, 2x Intel® Xeon® Processor E5-2697A v4 |
---|---|---|
System Description | Worker Nodes (WN): 9x HPE ProLiant DL380 Gen9 Management Nodes (MN): 3x HPE ProLiant DL360 Gen9 |
Worker Nodes (WN): 9x HPE ProLiant DL380 Gen9 Management Nodes (MN): 3x HPE ProLiant DL360 Gen9 |
Processor Information |
WN: E5-2697 v3 (2.60GHz, 35MB cache) |
WN: E5-2697A v4 (2.60GHz, 40MB cache) MN: E5-2640 v4 (25MB cache) |
Total Number of Sockets |
24 |
24 |
Total Number of Cores / Threads |
300 / 600 |
348 / 696 |
Memory Configuration (per node) |
WN: 128GB, 8x 16GB 2Rx4 PC4-2133P-R MN: 128GB, 8x 16GB 2Rx4 PC4-2133P-R |
WN: 192GB, 6x 32GB 2Rx4 PC4-2133P-R MN: 256GB, 8x 32GB 2Rx4 PC4-2133P-R |
Operating System |
Red Hat Enterprise Linux 6.7 |
Red Hat Enterprise Linux 6.7 |
Application Software |
Cloudera Enterprise 5.6 |
Cloudera Enterprise 5.6 |
Intel® Hyper-Threading Technology |
Yes | Yes |
Intel® Turbo Boost Technology 2.0 |
Yes | Yes |
Benchmark Name |
TPCx-BB @ 3000 |
TPCx-BB @ 3000 |
Performance BBQpm |
265.93 BBQpm @ 3000 |
337 BBQpm @ 3000 |
Price/Performance |
1,212.46 USD per BBQpm @ 3000 |
1,1.02.94 USD BBQpm @ 3000 |
Availability Date |
March 23, 2016 |
March 31, 2016 |
Data Source |
http://www.tpc.org/3501 |
submitted to www.tpc.org |
Additional information: 1 2 3 4 5 6 7
Informazioni su prodotti e prestazioni
I risultati dei benchmark sono stati ottenuti prima dell'implementazione delle patch software e degli aggiornamenti firmware più recenti volti a risolvere gli exploit denominati "Spectre" e "Meltdown". Con l'implementazione di tali aggiornamenti i risultati potrebbero non essere applicabili al dispositivo o al sistema in uso.
Le prestazioni variano in base all'utilizzo, alla configurazione e ad altri fattori. Per maggiori informazioni, consultare www.Intel.com/PerformanceIndex.
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.
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 ulteriori informazioni visitare il sito Web all'indirizzo https://www.intel.it/content/www/it/it/processors/processor-numbers.html.
Le prestazioni variano in base all'utilizzo, alla configurazione e ad altri fattori. Per maggiori informazioni, consultare www.Intel.com/PerformanceIndex.
Revisione avviso #20110804
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.
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.
I processori Intel® con la stessa SKU potrebbero variare a livello di frequenza o potenza a causa della naturale variabilità del processo di produzione.