Solution : https://service.sap.com/sap/support/notes/184905 (SAP Service marketplace login required)
Summary :
This SAP Note discusses performance issues related to data extraction, loading, and querying within the SAP Business Information Warehouse (BW) environment. It serves as a collective note addressing various performance-relevant aspects. Users are encouraged to download updated versions regularly and contribute improvement suggestions. The note lists updates and enhancements chronologically, covering areas such as extraction from OLTP systems, loading and query performance in BW, InfoCube optimizations, aggregate formations, and database-specific settings. It is a central resource aiming to enhance performance through collaborative and continuously updated guidelines.
Key words :
/ database-specific settings vii/ abap parameters viii/ recommended methodology papersi/ extraction, / aggregates vi/ ods vii/ infosetquery viii/ frontend, chronological order===============================date short description02/21/2002 update, xii/ recommended methodology papersalso refer, psa conversionx/ database-specific settingsoracle, / ec-pca + fi-sl extractionnote 307311, datenkorruption bei rtbb/buffer_length > 200000 mögl, performance probleme bei der aggregatbildungnote 337824, performance bw master data extraction 0hrpositionnote 319006, db2 udb eee indexing scheme
Related Notes :
| 618868 | FAQ: Oracle performance |
| 429594 | Condenser: performance problem at ORACLE |
| 423099 | "Low Speed Connection" Parameter and BEx Analyzer |
| 414220 | Data corruption possible if rtbb/buffer_length is > 200000 |
| 407528 | AS/400: DB2/400 indexing Schema of the BW Fact Tables |
| 390016 | DB2/390: BW: Database settings and performance |
| 387477 | Read mode for query: Setting gets lost |
| 380304 | InfoSet Query: Performance improvements |
| 375132 | Performance optimization for InfoCube condensation |
| 356732 | Performance Tuning for Queries with Aggregates |
| 354080 | Note collection for Oracle performance problems |
| 353377 | Performance improvement during change run |
| 351163 | Creating ORACLE DB statistics using DBMS_STATS |
| 339812 | Incorrect indexing of F-fact table on Oracle |
| 337754 | Performance problem in update as of PI 2000.1 SP4 |
| 336402 | Massive performance problems with 8.1.6 |
| 328322 | DB6: DB2 UDB EEE Indexing Scheme of BW Facttables |
| 325839 | Considerable increase of tablespace PSAPODSD |
| 323090 | Performance problems due to degenerated indexes |
| 319006 | CPU capacity overload in BW source system |
| 314719 | BW2.0 ORACLE FEATURES |
| 313215 | Performance BW master data extraction 0HRPOSITION |
| 311003 | performance improvement BW data load |
| 308537 | iSeries: Corrections for BW 2.0B / BW 2.1C |
| 308533 | Temporary Database Objects in BW 2.0 |
| 307311 | Performance line item reading with selection |
| 306827 | Aggregate Build Optimization |
| 217397 | Indexing Scheme of BW facttables under Oracle |
| 213083 | Packet size too small w/ EC-PCA + FI-SL extraction |
| 210219 | Performance when updating SAP BW from CO-PA |
| 198752 | TCP delay problem under Oracle 8.1.x |
| 196048 | Performance problems on HP-UX 11 after patch |
| 192658 | Setting parameters for BW systems |
| 190038 | Coll.note:InfoSource 0CO_PC_01 & 0CO_PC_02 prfrmnce |
| 181945 | Performance guide: BW on Informix |
| 180605 | Oracle database parameter settings for BW |
| 169798 | DB2 UDB EEE: Performance on BW 2.0A |
| 161053 | Using SAPGUI in WAN |
| 157652 | Main memory requirement for extraction from R/3 |
| 129252 | Oracle DB Statistics for BW Tables |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 117830 | Performance problems when creating aggregates |