I'm facing some performance problems to my SCM-DP. I suspect this is related to BW statistics. Due to this I disabled the active default flag from A to I in transaction DB21 only for BW tables like /BI0/*. I run daily the program /SAPAPO/TS_PSTRU_TOOL to collect statistics and check the indexes for my Active Planning Areas. Also I run daily the OS command brconnect -u / -c -f stats -t all -f collect to maintain up-to-date the statistics (SM69).
Also the statistics are kept for 180 days using the report RSDDSTAT_DATA_DELETE.
Thereafter, the DP run better...but the users are still reporting the poor performance.
Could you please help me to find ways to improve the performance?
Many thanks,
Albert.
Edited by: User Basis on May 2, 2011 11:05 PM