Skip to Content
Businesswoman presenting Benchmarks on graphical screens

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.

Main differences/extensions between BW-EML and BW-AML:

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

 

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

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
Back to top