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.
More on BI Performance Tuning
SAP BW Query Performance Tuning with Aggregates (Time: 00:51:44)
SAP BW Data Load Performance Analysis and Tuning (Time: 00:49:22)
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
Scalability in SAP Business Information Warehouse.
This white paper from Winter Corporation examines the performance and scalability of SAP Business Information Warehouse.
60 TB Proof of Concept
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.
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 pTM 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
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