DSO Activation taking longer time

[Former Member]

We are loading a DSO from infoset. We have around 55 lakh records to be loaded  in the DSO. No routines are involved.

The DSO activation takes around 10 hours which is very high.

We have unchecked the SID generation in DSO settings and also done the required setting in tcode RSODSO_SETTINGS.

Can anything else be done to improve DSO activation?

Regards,

Rahul

[former_member21257 · Accepted solution]

Hi Rahul,

This SAP Note is very useful for performance issues with DSO request activations:

1392715 - DSO req. activation: collective perf. problem note

Rgds,

Colum

[nilesh_vakil]

Hi,

You can distribute the activation load on various backgroudn work process by following way

1) Right click on DSO Activation step in process chain

2) Click on display variant

3) Click on parellal processing

4) Click on DSO activation

5) Increase work processes more thatn 3 ( 3 is default) with your basis person recomendation

6) also resude the activation package size by t-code' rsdo-setting'

[nilesh_vakil]

In process chain , please increse the number of assigned backgound processes to DSO. This will divide the load in multiple work processes and increase you to speed up the activation.

Right click on Process chain step of activation

1) Click on 'Dsiplay Variant'

2) Click on Parellal processing

3) Click on Number of processes ( By defual they are 3)

4) Increase these with consultation with Basis

5) also in 'RSDO_settings' reduce the package size of activation' so that load will get spread to multiple backgoudn processes we have definded.

[Former Member]

Hi,

Are you facing this issue only while activating it through process chain or even while doing it manually?

[Former Member]

Even while doing it manually . it takes same time.

[Former Member]

can you paste the screenshot of the activation log. It might provide better idea to give you some suggestion

[Former Member]

Hi Rahul,

Check this.

http://scn.sap.com/docs/DOC-32818

Regards,

Ganesh

[Former Member]

Please see attached doc

snapshot ref.txt.zip

[Former Member]

Hi Rahul,

Please find my observations and suggestions given below.

1. Based on your DSO activation log, it is not wasting the time in waiting for resources.

2. But it is spending too much time in executing the Program RSBATCH_EXECUTE_PROZESS.

Based on this, I browsed and found few issues which are listed below.

1. Please check whether OSS notes 1152831 if it is useful for you.

2. If you are in older version of SP, then upgrading it to the latest versions also would increase your system performance.

3. If this doesn't help, I would suggest to create a SAP message to reslove this issue.

[Former Member]

Hi,

Along with the above links...

Check this...

http://wiki.sdn.sap.com/wiki/display/BI/Performance+issue+during+DSO+request+activation

Regards,

Aravind.

[Former Member]

Hi Rahul,

Delete unwanted data from change log table. Data which is old and you don't expect that to change(very old historic data.this will improve your performance.

Regards,

Saurabh Singh