Friday, March 23, 2018

BW Performance Tuning

DSO Activation Statistics Generation
ODS Activation step periodically recalculates the statistics. This can be a overhead if the activation step is critical. In order to suppress the statistics step the document can be referred. The Document also mentions the need for statistics.


Delete entries using Program RSODSO_CLEANUP_RSODSACTUPDTYPE
Refer Note 2526515 to see if the table RSODSACTUPDTYPE is accumulating entries

Archiving Request Information in BW
Request-archiving is used to to archive reduce the size of administration and log tables e.g. RSMONMESS, RSSELDONE which can grow extensively LINK

Reducing Requests
TCode RSREQREDUCE helps to monitor the size of the requests for individual infoproviders.
Click HERE for more information.

Performance Improvement related Notes
SAP Note 2037093 : Performance problems during delta/init in the status management with DTP-s between infoproviders

Data Archival

No comments:

Post a Comment