Performance Tuning

Performance is a critical issue in developing a data warehouse because of the size of data in the system. Earlier in this book, we explicitly discussed techniques to help improve performance. For example, in Chapter 7, we considered how to design an InfoCube so that its queries will have better performance.

Two types of performance measurements exist: system throughput and response time. System throughput usually applies to OLTP systems, which are designed to process thousands or even millions of small transactions per day. In contrast, response time typically applies to OLAP systems, which are designed to process massive parallel queries that fetch and sort hundreds of thousands of records from various tables.

The following tactics have proved very effective when tuning performance and are recommended by Oracle:

  1. Set clear goals for tuning.
  2. Create minimum repeatable tests.
  3. Test hypotheses.
  4. Keep records.
  5. Avoid common errors.
  6. Stop tuning when the objectives are met.
  7. Demonstrate meeting the objectives.

In this chapter, we will first show how to install and use BW Statistics, a BW tool for performance measurement. We will also briefly discuss System Administration Assistant, an SAP function for general system performance monitoring. Finally, we will discuss techniques for tuning query performance and load performance.


The discussion in this chapter applies to Oracle on HP-UX. Refer to the BW documentation for information on other platforms.

Part I. Guided Tours

Business Scenario and SAP BW

Creating an InfoCube

Loading Data into the InfoCube

Checking Data Quality

Creating Queries and Workbooks

Managing User Authorization

Part II. Advanced Topics

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography

SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
Year: 2002
Pages: 106 © 2008-2020.
If you may any questions please contact us: