Main differences/extensions between BW-EML and BW-AML:
Advanced Mixed Load (BW-AML)
The SAP BW Advance Mixed Load Benchmark (BW-AML Benchmark) is the successor of the popular BW-EML benchmark which was retired recently. The new BW-AML meets the most current demands of typical business warehouse customers.
Data-mart (BI-D)
The data mart scenario is one use of the Business Intelligence capabilities of SAP NetWeaver. The data mart contains a static snapshot of operational data. Multiple users run queries on this data in 10 InfoCubes which contain 2,500,000,000 records. The key figure is the number of query navigation steps/hour.
SAP BI Data Mart Standard Application - Two-Tier: SAP NetWeaver 2004s
| Date of Certification (mm/dd/yyyy) | Technology Partner | Query Navigation Steps/ Hour | Operating System - Release | RDBMS Release | SAP NetWeaver Release | Central Server | Number of Processors | Number of Cores | Number of Threads | CPU Type | CPU Speed (MHz) | CPU Cache | Central Server Memory (MB) | Certification Number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3/30/2010 | Fujitsu | 854649 | SuSE Linux Enterprise Server 10 | Oracle 11g Real Application Clusters (RAC) | SAP NetWeaver 7.0 (non-Unicode) | Fujitsu PRIMERGY RX600 S5 | 4 | 32 | 64 | Intel Xeon Processor X7560 | 2260 | 4 KB L1 cache and 256 KB L2 cache per core, 24 MB L3 cache per processor | 131072 | 2010011 |
| 10/12/2009 | Fujitsu | 320363 | SuSE Linux Enterprise Server 10 | Oracle 10g Real Application Clusters (RAC) | SAP NetWeaver 7.0 (non-Unicode) | Fujitsu Primergy RX300-S5 | 2 | 8 | 16 | Intel Xeon Processor X5570 | 2930 | 64 KB L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per processor | 98304 | 2009036 |
| 10/31/2008 | IBM | 182112 | i 6.1 | DB2 for i 6.1 |
SAP NetWeaver 7.0 (2004s) | IBM Power System 570 | 4 | 8 | 16 | POWER6 | 5000 | 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor | 131072 | 2008063 |
| 4/8/2008 | IBM | 40445 | i 6.1 | DB2 for i 6.1 |
SAP NetWeaver 7.0 (2004s) | IBM Power System 520 Express | 1 | 2 | 4 | POWER6 | 4200 | 128 KB L1 cache and 4 MB L2 cache per core | 32768 | 2008020 |
| 10/22/2007 | IBM | 26224 | i5/OS V5R4 | DB2 for i5/OS V5R4 | SAP NetWeaver 7.0 (2004s) | IBM System i 520 | 2 | 2 | 4 | POWER5+ | 1900 | 32 KB(D) + 64 KB(I) L1 cache per processor, 1.9 MB L2 cache and 36 MB L3 cache per 2 processors | 16384 | 2007061 |
| 7/24/2007 | IBM | 92716 | i5/OS V5R4M5 | DB2 for i5/OS V5R4M5 | SAP NetWeaver 7.0 (2004s) | IBM System i 570 | 2 | 4 | 8 | POWER6 | 4700 | 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor | 65536 | 2007047 |
| 4/19/2007 | IBM | 114687 | i5/OS V5R4 | DB2 for i5/OS V5R4 | SAP NetWeaver 2004s | IBM System i5 570 | 8 | 8 | 16 | POWER5+ | 2200 | 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache | 131072 | 2007027 |
| 01/25/2007 | IBM | 51875 | i5/OS V5R4 | DB2 for i5/OS V5R4 | SAP NetWeaver 2004s | IBM System i5 570 | 4 | 4 | 8 | POWER5+ | 2200 | 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache | 65536 | 2007003 |
SAP BI Data Mart Standard Application - Three-Tier: SAP NetWeaver 7.0
| Date of Certification (mm/dd/yyyy) | Technology Partner | Query Navigation Steps/ Hour | Operating System – Release | RDBMS Release | SAP NetWeaver Release | Database Servers | Database Server Memory (MB) | Number & Type of Application Servers | Certification Number |
|---|---|---|---|---|---|---|---|---|---|
| 5/31/2010 | Fujitsu | 1624629 | SUSE Linux Enterprise Server 10 | Oracle 11g Real Application Clusters (RAC) | SAP NetWeaver 7.0 (non-Unicode) | 2 x Fujitsu Primergy RX600 S5, 4 processors / 32 cores / 64 threads, Intel Xeon Processor X7560, 2,26 GHz, 64 KB L1 cache and 256 KB L2 cache per core, 24 MB L3 cache per processor; 1 server 128 and one server 256 GB main memory | 1 x 131072 and 1 x 262144 | ran on database server | 2010024 |
| 11/9/2009 | Fujitsu | 1,165,742 | SuSE Linux Enterprise Server 10 | Oracle 10g Real Application Clusters (RAC) | SAP NetWeaver 7.0 (non-Unicode) | 4 x Fujitsu Primergy RX300-S5, 2 processors / 8 cores / 16 threads, Intel Xeon Processor X5570, 2.93 GHz, 64 KB L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per processor | 4 x 98304 | ran on database server | 2009045 |
| 11/9/2009 | Fujitsu | 900.309 | SuSE Linux Enterprise Server 10 | Oracle 10g Real Application Clusters (RAC) | SAP NetWeaver 7.0 (non-Unicode) | 3 x Fujitsu Primergy RX300-S5, 2 processors / 8 cores / 16 threads, Intel Xeon Processor X5570, 2.93 GHz, 64 KB L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per processor | 3 x 98304 | ran on database server | 2009044 |
| 10/12/2009 | Fujitsu | 609349 | SuSE Linux Enterprise Server 10 | Oracle 10g Real Application Clusters (RAC) | SAP NetWeaver 7.0 (non-Unicode) | 2 x Fujitsu Primergy RX300-S5, 2 processors / 8 cores / 16 threads, Intel Xeon Processor X5570, 2.93 GHz, 64 KB L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per processor | 2 x 98304 | ran on database server | 2009037 |
Note: The BI-D results can not be compared with the results of the query phase of the BW benchmark as different queries are executed.
Mixed Load (BI-XML)
The mixed load scenario is one use of the Business Intelligence capabilities of SAP NetWeaver.
SAP NetWeaver 2004s and SAP NetWeaver 7.0, Without BI Accelerator 300,000,000 records
| Date of Certification (mm/dd/yyyy) | Technology Partner | Number of records | Query Navigation Steps/ Hour | Operating System – Release Database Server | RDBMS Release | SAP NetWeaver Release | Number & Type of Database/Application Servers | Certification Number |
|---|---|---|---|---|---|---|---|---|
| 11/30/2010 | IBM | 300,000,000 | 625646 | i 7.1 | DB2 for i 7.1 | SAP NetWeaver 7.0 | IBM Power System 780, 4 processor / 16 cores / 64 threads, POWER7, 4100 MHz, 32 KB(D) + 32 KB(I) L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per core | 2010047 |
| 8/17/2010 | IBM | 300,000,000 | 151,426 | i 7.1 | DB2 for i 7.1 | SAP NetWeaver 7.0 | IBM Power System 740, 1 processor / 4 cores / 16 threads, POWER7, 3.30 GHz, 32 KB(D) + 32 KB(I) L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per core, 64 GB main memory | 2010035 |
| 4/13/2010 | IBM | 300,000,000 | 278462 | i 7.1 | DB2 for i 7.1 | SAP NetWeaver 7.0 | IBM Power System 750, 1 processor / 8 cores / 32 threads, POWER7, 3.30 GHz, 32 KB(D) + 32 KB(I) L1 cache and 256 KB L2 cache per core, 4 MB L3 cache per core, 128 GB main memory | 2010014 |
| 2/8/2010 | IBM | 300,000,000 | 241526 | i 6.1 | DB2 for i 6.1 | SAP NetWeaver 7.0 | IBM Power System 750, 1 processor / 8 cores / 32 threads, POWER7, 3.30 GHz, 32 KB(I) + 32 KB(D) L1 cache and 256 KB L2 cache per core, 4 MB L3 cache per core, 128 GB main memory | 2010005 |
| 10/20/2009 | IBM | 300,000,000 | 154447 | i 6.1 | DB2 for i 6.1 | SAP NetWeaver 7.0 | IBM Power System 570, 4 processors / 8 cores / 16 threads, POWER6, 4.2 GHz, 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor, 128 GB main memory | 2009043 |
| 4/28/2009 | IBM | 300,000,000 | 90,635 | i 6.1 | DB2 for i 6.1 | SAP NetWeaver 7.0 | IBM Power 550, 2 processors / 4 cores / 8 threads, POWER6, 5.0 GHz, 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor, 64 GB main memory | 2009011 |
| 4/28/2009 | IBM | 300,000,000 | 90,492 | i 6.1 | DB2 for i 6.1 | SAP NetWeaver 7.0 | IBM Power 550, 2 processors / 4 cores / 8 threads, POWER6, 5.0 GHz, 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor, 64 GB main memory | 2009010 |
| 3/19/2009 | IBM | 300,000,000 | 41,090 | i 6.1 | DB2 for i 6.1 | SAP NetWeaver 7.0 | IBM Power 520, 1 processor / 2 cores / 4 threads, POWER6, 4.7 GHz, 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor, 32 GB main memory | 2009002 |
| 12/8/2008 | IBM | 300,000,000 | 93.468 | i 6.1 | DB2 for i 6.1 | SAP NetWeaver 7.0 | IBM Power System 570, 2 processors / 4 cores / 8 threads, POWER6, 5.0 GHz, 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor, 96 GB main memory | 2008069 |
SAP BW edition for SAP HANA Benchmark Version 1-3
Employee Self-Service Portal (EP-ESS)
The Employee Self-Service Portal (EP-ESS) Benchmark is part of the SAP Standard Application Benchmark suite for SAP NetWeaver Portal.
SAP NetWeaver Portal 6.0 and 7.0
| Date of Certification (mm/dd/yyyy) | Technology Partner | Number of Portal Users | Average Online Response Time (sec) | Number of Top Level Navigation Steps/Hour | Operating System - Release | JSE - Version | SAP NetWeaver Release | Central Server | Number of processors | Number of cores | Number of threads | CPU Type | CPU Speed (MHz) | Cache | Central Server Memory (MB) | Certification Number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8/30/2007 | IBM | 2600 | 1.81 | 792619 | AIX 5L Version 5.3 | IBM Java 1.4.2 | 7.0 (2004s) | IBM System p 570 | 2 | 4 | 8 | POWER6 | 4700 | 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3 cache per processor | 32768 | 2007052 |
| 4/7/2006 | Dell | 1941 | 1.99 | 583000 | SuSE Linux Enterprise Server 9 (64-bit) | IBM JSE 1.4.2 (64-bit) | 2004 (64-bit) | Dell PowerEdge Model 6850 | 4 | 8 | 16 | Intel XEON Dual-Core | 3000 | 16 KB L1 cache, 2 MB L2 cache | 32768 | 2006017 |
| 03/02/2006 | Sun | 1440 | 1.94 | 433912 | SuSE Linux Enterprise Server 9 (64-bit) | IBM JSE 1.4.2 (64-bit) | 2004 (64-bit) | Sun Fire Model V20z | 2 | 4 | 4 | Dual-core AMD Opteron processor Model 275 | 2200 | 128 KB L1 cache, 1 MB L2 cache | 8192 | 2006012 |