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 |