SAP Business Information Warehouse (BW) Standard Application Benchmark Results, Releases 3.0B - 3.5

Download in tab-delimited text format

Date of Certification (mm/dd/yyyy) Technology Partner Step Throughput / Hour Number of Records in Fact Table (Memory) Operating System - Release RDBMS Release SAP Netweaver / Technology Release BW Release Central Server DB server memory (MB) Certification Number
09/05/2006 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 52,890,566


Average no. of rows: 48,459,145
(Average throughput total 25,288,988)

Navigation steps: 125,460
(CPU util. of central system: 98%)
116,800,000
(8 GB main memory) 
i5/OS V5R4 DB2 UDB for i5/OS V5R4 SAP NetWeaver 2004 3.5 IBM eServer i5 Model 570, 4 processors / 4 cores / 8 threads, POWER5+, 2.2 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 8 GB main memory 8192 2006072
08/04/2006 HP Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 54,621,980


Average no. of rows:35,864,893
(Average throughput total 21,649,676)

Navigation steps: 97,344
(CPU util. of central system: 99%)
116,800,000
(8 GB main memory) 
HP-UX 11iV2 Oracle 10g SAP NetWeaver '04 3.5 HP Integrity Model rx4640, 4 processors / 4 cores / 4 threads, Intel Itanium 2, 1.6 GHz, 32 KB L1 cache, 256 KB L2 cache, 9 MB L2 cache, 8 GB main memory 8192 2006048
06/12/2006 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 77,550,719


Average no. of rows: 67,498,194
(Average throughput total 67,498,194)

Navigation steps: 437,760
(CPU util. of central system: 94%)
233,600,000
(16 GB main memory) 
i5/OS V5R4 DB2 UDB for i5/OS V5R4 SAP NetWeaver '04 3.5 IBM eServer i5 Model 570, 16 processors / 16 cores / 32 threads, POWER5+, 2.2 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 16 GB main memory 16384 2006036
03/14/2006 Fujitsu Siemens Computers Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 256,155,955


Average no. of rows: 67,233,770
(Average throughput total 53,255,652)

Navigation steps: 377,280
(CPU util. of central system: 99%)
467,200,000
(32 GB main memory) 
Solaris 10 Oracle 10g SAP NetWeaver '04 3.5 Fujitsu PRIMEPOWER Model PW850, 16 processors / 16 cores / 16 threads, SPARC64 V, 2.16 GHz, 128 KB(D) + 128 KB(I) L1 cache, 4 MB L2 cache, 32 GB main memory 32768 2006014
01/24/2006 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 106,168,413


Average no. of rows: 52,523,890
(Average throughput total 35,139,562)

Navigation steps: 250,236
(CPU util. of central system: 97%)
233,600,000
(16 GB main memory) 
i5/OS V5R4 DB2 UDB for i5/OS V5R4 SAP NetWeaver '04 3.5 IBM eServer i5 Model 570, 8 processors / 8 cores / 16 threads, POWER5+, 2.2 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 16 GB main memory 16384 2006004
12/22/2005 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 74,152,191


Average no. of rows: 22,598,554
(Average throughput total 17,320,097)

Navigation steps: 178,164
(CPU util. of central system: 97%)
233,600,000
(16 GB main memory) 
i5/OS V5R3 DB2 UDB for i5/OS V5R3 SAP NetWeaver '04 3.5 IBM eServer i5 Model 570, 8 processors / 8 cores / 16 threads, POWER5, 1.65 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 16 GB main memory 16384 2005051
12/5/2005 Fujitsu Siemens Computers Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 134,274,309


Average no. of rows: 55,644,809
(Average throughput total 39,341,317)

Navigation steps: 182,340
(CPU util. of central system: 99%)
233,600,000
(16 GB main memory) 
Solaris 10 Oracle 10g SAP NetWeaver '04 3.5 Fujitsu PRIMEPOWER 650, 8 processors/ 8 cores/ 8 threads, SPARC64 V, 2.025 GHz, 128 KB(D) + 128 KB(I) L1 cache, 3 MB L2 cache, 16 GB main memory 16384 2005046
06/24/2005 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 79,395,770


Average no. of rows: 18,429,173
(Average throughput total 14,957,314)

Navigation steps: 179,208
(CPU util. of central system: 99%)
233,600,000
(16 GB main memory) 
i5/OS V5R3 DB2 UDB for i5/OS V5R3 SAP NetWeaver '04 3.5 IBM eServer i5 Model 570, 8-way SMP, POWER5, 1.65 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 16 GB main memory 16384 2005027
03/09/2005 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 34,411,981


Average no. of rows: 11,408,416
(Average throughput total 8,567,935)

Navigation steps: 90,324
(CPU util. of central system: 99%)
116,800,000
(8 GB main memory)
i5/OS V5R3 DB2 UDB for i5/OS V5R3 SAP NetWeaver '04 3.5 IBM eServer i5 Model 550, 4-way SMP, POWER5, 1.65 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 8 GB main memory 8192 2005011
12/09/2004 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 34,302,496


Average no. of rows: 11,186,549
(Average throughput total 8,435,582)

Navigation steps: 78,948
(CPU util. of central system: 96%)
116,800,000
(8 GB main memory)
i5/OS V5R3 DB2 UDB for i5/OS V5R3 4.70
(Web AS 6.20)
3.0 B IBM eServer i5 Model 550, 4-way SMP, POWER5, 1.65 GHz, 32 KB(D) + 64 KB(I) L1 cache, 1.9 MB L2 cache, 36 MB L3 cache, 8 GB main memory 8192 2004073
05/25/2004 Unisys Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 66,918,119


Average no. of rows: 13,874,251
(Average throughput total 11,491,664)

Navigation steps: 154,656
(CPU util. of central system: 83%)
233,600,000
(16 GB main memory)
Windows Server 2003 Datacenter Edition (64-bit) SQL Server 2000 (64-bit) 4.70 (64-bit)
(Web AS 6.20)
3.1 Unisys ES7000 Model Orion 430, 16-way SMP, Intel Itanium 2, 1.5 GHz, 32 KB L1 cache, 256 KB L2 cache, 6 MB L3 cache 16384 2004026
05/04/2004 IBM Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 33,515,065


Average no. of rows: 10,954,707
(Average throughput total 8,256,119)

Navigation steps: 98,424
(CPU util. of central system: 96%)
233,600,000
(16 GB main memory)
SuSE Linux Enterprise Server 8 (64-bit) DB2 UDB 8.1 SAP NetWeaver '04 3.5 IBM xSeries 455 Model 8855-3RX, 8-way SMP, Intel Itanium 2, 1500 MHz, 32 KB L1 cache, 256 KB L2 cache, 6 MB L3 cache 16384 2004021
09/04/2003 HP Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 24,108,018


Average no. of rows: 10,648,972
(Average throughput total 7,386,302)

Navigation steps: 66,852
(CPU util. of central system: 99%)
233,600,000
(16 GB main memory)
Windows Server 2003 Enterprise Edition SQL Server 2000 4.70
(Web AS 6.20)
3.0 B hp Integrity RX server Model 5670, 4-way Intel Itanium 2 1500 MHz, 6 MB L3 cache 16384 2003043
07/14/2003 HP Step 1: Load Phase -
Part 1

Step 2: Load Phase -
Part 2

Step 3: Query phase
Average no. of rows: 37,472,596


Average no. of rows: 6,686,810
(Average throughput total 5,674,264)

Navigation steps: 81,792
(CPU util. of central system: 95%)
116,800,000
(8 GB main memory)
Windows 2003 Enterprise Edition SQL Server 2000 4.70
(Web AS 6.20)
3.0 B hp ProLiant Model DL740, 8-way Intel Xeon MP 2870 MHz, 2 MB L3 cache 8,192 2003038