SAP Business Information Warehouse (BW) Standard Application Benchmark Results, Releases 1.2 - 2.0B
Download in tab-delimited text format
| Date of Certifcation (mm/dd/yyyy) | Technology Partner | Step | Throughput / Hour | Number of Records in Fact Table (Memory) | Operating System - Release | RDBMS Release | Technology Release | BW Release | Central Server | DB server memory (MB) | Certification Number |
| 02/08/2001 | Compaq | Step 1: Load phase Step 2: Realignment Step 3: Query phase |
Average no. of rows: 25,366,795 No. of rows: 108,287,407 (total runtime: 1.05 hrs) Navigation steps: 46,094 (CPU util. of central system: 99%) |
116,800,000 (8 GB main memory) |
Compaq Tru64 Unix V. 5.1 | Oracle 8.1.6 | 4.6 C | 2.0 B | Alphaserver ES40, 4-way Alpha 21264 EV68 833 MHz, 8 MB L2 Cache | 8,192 | 2001004 |
| 12/28/2000 | Compaq | Step 1:
Load phase Step 2: Realignment Step 3: Query phase |
Average no. of rows: 114,509,804
No. of rows: 313,849,599 (total runtime: 1.29 hrs) Navigation steps: 207,323 (CPU util. of central system: 92%) |
467,200,000 (32 GB main memory) |
Compaq Tru64 Unix V. 5.1 | Oracle 8.1.6 | 4.6 C | 2.0 B | Alphaserver Model GS320, 32-way Alpha 21264 EV67 731 MHz, 4 MB L2 Cache | 32,768 | 2000032 |
| 06/16/2000 | Compaq | Step 1:
Load phase Step 2: Realignment Step 3: Query phase |
Average no. of rows: 2,125,546
No. of rows: 10,657,000 (total runtime: 5.29 hrs) Navigation steps: 38,815 (CPU util. of central system: 95%) |
116,800,000 (8 GB main memory) |
Windows 2000 | MS SQL Server 2000 | 4.5 B | 1.2 B | ProLiant Model 8000, 8-way Pentium III Xeon 700 MHz, 2 MB L2 Cache | 4,096 | 2000016 |
| 01/31/2000 | IBM | Step 1:
Load phase Step 2: Realignment Step 3: Query phase |
Average no. of rows: 3,144,179
No. of rows: 14,600,000 (total runtime: 8.13 hrs) Navigation steps: 115,570 (CPU util. of central system: 84%) |
58,400,000
(4 GB main memory) |
AIX 4.3.3 | DB/2 UDB 6.1 | 4.5 B | 1.2 B | IBM RISC System / 6000 Model S80, 24-way Power PC-RS64-III, 450 MHz, 8MB L2 cache | 8,192 | 2000001 |