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