尤尼佳08_CERT0401.docVIP

The SAP Business Information Warehouse 2.0 B Standard Application Benchmark suite performed on January 26th, 2001, by Compaq in Littleton, USA, was certified on February 8th 2001, with the following data: The scenario for 8 GB main memory, which corresponds to 116,800,000 records in fact table, was used. Step 1: Load Phase Average throughput in rows / hour: 25,366,795 in detail: Load from ODS into Infocube (rows / hour): 33,424,483 Repair 2nd indeces on facttable (rows / hour): 846,036,217 Create statistics on facttable (rows / hour): 2,766,315,789 Rollup of aggregates (rows / hour): 125,628,921 Step 2: Realignment No. of rows / hour: 108,287,407 Total runtime: 1 hour 05 minutes Step 3: Query phase Throughput / hour: 46,094 query navigation steps CPU utilization of central system: 99% The software configuration for all three steps of the SAP BW benchmark: Operating System central server: Compaq True64 Unix V. 5.1 RDBMS: Oracle 8.1.6 SAP BW Release: 2.0 B Total disk space: 1,308 GB Configuration: Central Server: Compaq Alphaserver ES40, 8-way, Alpha 21264 EV68, 833 MHz, 8 MB L2 cache, 8 GB main memory Standard Application Benchmarks Certification Confirmation Certification Number 2001004 ___________________________________________________________________________________ ( SAP AG 2001 Page 1/1