Business Intelligence Performance Tuning

Use the information and links on this page to get an overview of SAP Business Intelligence features and settings that impact performance, and of the tools that help identify and address performance problems. See also the documents published on the BI Accelerator pages.

Getting Started
More on BI Performance Tuning
5 TB Showcase
60 TB Proof of Concept
Project Jupiter

Getting Started

BW Performance Tuning (Workshop Presentation) (PDF 6 MB)

This comprehensive slide presentation encompasses the most important performance issues of BW, broken down into the following sections: General Settings and Checklist, Modeling, Query Performance, Extraction/Data Load Performance, and Analysis Methods.

More on BI Performance Tuning

SAP BW Query Performance Tuning with Aggregates (Time: 00:51:44)

In this eLearning session, Ron Silberstein of the SAP NetWeaver Regional Implementation Group introduces the role Aggregates play in improving BI performance, and then discusses how to build and maintain Aggregates and measure the performance improvements they can provide.

SAP BW Data Load Performance Analysis and Tuning (Time: 00:49:22)

In the second eLearning of the series, Ron Silberstein examines data load performance and the steps you can take to better understand, and then improve, extractor performance.

SAP BI Best Practice: Periodic Jobs and Tasks (PDF 900 KB)

This SAP Best Practice guide describes jobs and tasks that must be performed on a regular basis to ensure system performance and stability in an SAP BW system. Look here for advice on what to do, when, and how regarding monitoring, performance tuning, aggregate maintenance, data management, transports, and more.

5 TB Showcase

The 5 Terabyte Showcase (PDF 1 MB)

Scalability in SAP Business Information Warehouse.

SAP BW Multi-Terabyte Evaluation and Feasibility Test (PDF 691 KB)

This white paper from Winter Corporation examines the performance and scalability of SAP Business Information Warehouse.

60 TB Proof of Concept

Extreme Business Warehousing: Experiences with SAP Netweaver BI at 20 Terabytes (IBM White Paper)

Series of three whitepapers documenting a Proof of Concept for SAP NetWeaver BI at 20 Terabytes based on actual business requirements done by IBM and SAP for a large international consumer goods enterprise.

These whitepapers are targeted at the IT Architect and IT Specialist level responsible for design and implementation. The infrastructure is system p with DB2 DPF and Tivoli Data Protection. The documents cover the scaling of the combined online load requirements and the administration and disaster recovers scenarios for this large critical database.

Infrastructure Solutions: Design, Manage, and Optimize a 60 TB SAP NetWeaver Business Intelligence Data Warehouse (IBM Redbook)

This IBM Redbooks® publication describes the testing that was done in terms of performance and manageability in an SAP NetWeaver® BI and DB2® environment on IBM System p^TM when scaling a client's solution to a data warehouse of 60 terabytes (TB). This book resulted from a joint cooperative effort that included the PSSC, the IBM/SAP International Competency Center, the DB2-SAP Center of Excellence, SAP AG, and a customer. The customer involved in this project is a worldwide company employing more than 250,000 employees with factories and logistics operations in almost every country in the world

Project Jupiter

Project Jupiter: 25 TB Showcase for BI Accelerator (PDF 1 MB)

This Whitepaper from Winter Corporation shows a large-scale testing of the SAP NetWeaver BI Accelerator on an IBM platform.

Best Practices for SAP BI using DB2 9 for z/OS (IBM Redbook)

Clients want to know how to exploit the new features of both DB2 V9 and SAP in their SAP BI environments. This IBM Redbooks publication describes the benefits of DB2 V9 for SAP Business Information Warehouse. It covers best practices and provides performance and tuning recommendations. This book describes best practices for this product on a zSeries platform, and provides performance and tuning recommendations for loading and querying data. It also addresses general system administration and troubleshooting. The audience for this book includes SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed