Solution : https://service.sap.com/sap/support/notes/892513 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues encountered during the loading of large datasets into BW systems, where increased data packages per request negatively impact performance, and substantial requests can cause termination due to insufficient tablespace. The solution advises limiting the number of data packages to 1000 and records to 10 million per request to minimize performance degradation. For multiple data targets, the data packages should be proportionately divided. Attachment includes a demonstration with various data package sizes, showing that performance issues escalate with over 1500 packages. Related notes for further reference include Note 894771, 620361, and 543212.
Key words :
ms excel sheet describing, monitor protocol chip selects, data package upper limit, large delta/repeat requests, psa process/reconstruction receives, psa process/reconstruction logs, data targets tablespace reason, delta/repeat requests, monitor protocol chip, protocol chip carries
Related Notes :
| 1597364 | FAQ: BW-BCT: Extraction performance in source system |
| 1392715 | DSO req. activation:collective perf. problem note |
| 1292059 | Consulting: More data packages than MAXDPAKS in delta/repeat |
| 894771 | Perform problems w/ sales statistics/unbilled rev reporting |
| 620361 | Data loading performance/Admin. data target, many requests |
| 543212 | Multiple daily data loads into same InfoCube |