Problem with performance of BW
I have a problem with the perfomance of BW. Every day in the morning, the BW it’s very slow, probably because many users are consuming the Sales Infocube when they generate reports in Sap BEX, but there are a BO user that consume resources of this infocube too. Everyday this user is scheduled to extract data from BW to BO starting at 3:00 AM and in transaction st22 always have dumps for this user. This dumps generally are Time Out or not enough space in memory to complete the task.
The BW Server has 16GB RAM.
Could you give me ideas to solve this problem?
I hope you should be posting it as a question in the related forum to get better response and not as a Blog Post.
Yes, is a question sorry