We have DSO loading performance issue. It is standard DSO and loading from external system (Web Methods)
We have tried all the possible things like, RSRV check and activated the DSO in production itself through program.
There are no secondary indexes created for the DSO.
It is taking more than 5 hours to loads or sometimes it crosses more than 10 hours. Previously it is used to complete within 1 hour.
It is 3.x Flow and data loading to PSA and DSO parallely.
Note: 1 month back patch upgrade (SAP BW 7.0, SP17) was done and this issue is available since last 10 days.
Please let me know your feedback. Thanks in advance!