尤尼佳27_Performance_Tuning.doc

Performance Tuning For SAP BW Business Information Warehouse Performance Tuning for SAP BWDocument Version 2.4 (July 7, 2003) Please Download This Document Regularly As It Might Be Subject To Changes Table of Contents 1 Introduction 1 1.1 Strategic Performance Management 1 1.2 Target Group 2 1.3 How To Read This Document 2 1.4 Software Version Supported 3 2 Basic Settings 4 2.1 Database and system parameters 4 2.1.1 Oracle-specific DB settings 4 2.1.2 Settings when using Web Frontend 5 2.2 Checklist 5 2.2.1 Query and Web Performance 5 2.2.2 Upload Performance 6 3 General Performance-influencing Factors 7 3.1 Design 7 3.1.1 Data Modeling 7 3.2 Hardware and Resources 10 3.2.1 Hardware Impact 10 3.2.2 IT Landscape and Configuration 11 3.3 Administration 12 3.3.1 Archiving 12 3.3.2 Load Balancing 12 3.3.3 Reorganization of Log Tables 13 3.3.4 Traces and logs 13 4 Extraction in the Source System (Service-API) 14 4.1 General 14 4.1.1 Settings of Extractors 14 4.1.2 Indices on DataSource tables 14 4.1.3 Customer Enhancements 15 4.2 Application-specific Settings 15 4.2.1 Logistics Extractors 15 4.2.2 LIS InfoStructures 16 4.2.3 CO Extractors 16 5 Data Load Performance 17 5.1 General 17 5.1.1 Upload Sequence 17 5.1.2 PSA Partition Size 17 5.1.3 Parallelizing Upload 18 5.1.4 Transformation Rules 18 5.1.5 Export DataSource 19 5.2 Flat File Upload 19 5.2.1 Flat File Upload 19 5.3 Load of Master Data 20 5.3.1 Buffering Number Range 20 5.3.2 Change Run 20 5.4 Upload into an InfoCube 20 5.4.1 Dropping Indices before Loading 20 5.4.2 Buffering Number Range 21 5.4.3 Compression 21 5.4.4 Roll-Up 21 5.4.5 Change Run 22 5.4.6 Request Handling 24 5.5 Upload into an ODS object 24 5.5.1 ODS Objects Data Activation 24 5.5.2 Indices 25 5.5.3 Data Activation Performance and Flag “BEx Reporting” 25 5.5.4 Unique Records in ODS Objects 25 5.5.5 Request Handling 26 6 Query Performance 27 6.1 Query Definition 27 6.1.1 Query Definition 27 6.1.2 Virtual Key Figures / Characteristics 29 6.1.3