Process chain performance

[Former Member]

I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading

Message was edited by: P Renjith Kumar

[RamanKorrapati · Accepted solution]

Hi Ramesh,

plz follow the SCN rules and keep proper heading as your issues.

Loading data performance is depend on the volume of data which is coming from Source. there is no fixed volume of data which is flowing business day to day.

as well if you think that any performance issues then you need follow the tips which are helpful in loading wise.

Like..Maintaining aggregates, filling aggregates, Cube compression, before loading to cube need delete indexes, after loding data into cube need to build index which are helpful in reporting wise, at DTP level maintaining of error handling options, Error stack to maintain erroneous records with out disturbing the load and some times servers will be busy. loading performance wise lot of scn thread are there. plz go thru it. process chain delaying day by day mean we can't come to conclusion lot of points need to consider which i said above...

Hope this may helps, assign points its helpful..

regards

[anshu_lilhori · Accepted solution]

Hi KR,

You can directly report abuse such threads it makes the job of moderators easy in locking the threads.

These type of threads and questions are not worth for explanation and points.

Regards,

AL

[RamanKorrapati · Accepted solution]

Hi AL,

Thank you Anshu, Sure, i will do that.i seen in last two weeks, some people are just posting and going away, there is no replies also....now onwards i will follow the same.

regards

[Former Member · Accepted solution]

Hi KR Chowthary,

Sorry for late reply and i am very new for sdn.So i did lot of mistake also.but dont worry i am trying to follow all the rule of sdn.And thanks a lot for ur reply and suggestion.

Thanks & Regards

Ramesh kumar

[RamanKorrapati · Accepted solution]

hi Ramesh,

If any one of Guru Reply is useful or correct answer or assumed one,

As per the that above options , choose right one and close this thread.

Once the thread have proper answer then this thread will be reference SCN if same issue occurs.

Hope you understand.

Regards

[Former Member · Accepted solution]

Hi,

I want to know more about process chain and wt is happening in support project .i mean end to end process of process chain. can you plz suggest me any blogs or any doct or any website .So i can easy understand.

Regards

Ramesh

[RamanKorrapati · Accepted solution]

Hi Ramesh,

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/502b2998-1017-2d10-1c8a-a57a35d52...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/101bed70-f13d-2e10-e7ad-d5c9dabf4...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a1f389-ec7c-2c10-04bc-9d81b3084...

http://help.sap.com/saphelp_erp60_sp/helpdata/en/47/9e9290dac60985e10000000a42189c/content.htm

http://airccse.org/journal/acij/papers/0312acij09.pdf

http://raj-bi.blogspot.in/2009/09/process-chains.html

http://satyasapbwbi.blogspot.in/2011/01/process-chain-creation.html

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/101bed70-f13d-2e10-e7ad-d5c9dabf4...

http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r1/index.jsp?topic=/com.ibm.swg.im.iis.ds.entpak...

regards

[Former Member]

Hi Ramesh,

You can go to sm13 and analyse and identify the particular step(s) which are taking long to execute.

SM13 gives you the idea of each step execution time and current status.

There might be several reasons why the process chain execution is taking a long time. If there is a data load delay, go to the monitor of the data load and identify the step where it takes  a long time.

The process chain running late could also be due to lack of resources. You can check with Basis team on this.

There might be a case in which a process in the process chain might be dependent on some jobs to complete and the job might have got delayed.

The first step would be to identify the step where it seems to have taken the most time for execution.

Hope this helps.

Thanks & Regards,

Debashish

[Former Member]

Hi Debashish,

thanks a lot for your reply.

Thanks and Regards

Ramesh kumar.

[RenjithKumar]

Hi Ramesh,

Your initial subject for this thread was your name!

I have edited your subject. I would suggest what chowthary suggested.

Kindly follow the SCN rules and try to proper heading for your future issues. It will help you to get response even better.

Regards

P Renjith Kumar

BI forum moderator

[Former Member]

Hi P Renjith,

Thanks a lot for edit of my subject line...

Regards

Ramesh Kumar

[former_member182470]

Hi,

You need to analyze the trend of your process chain. Click on Log view and select past 1 week.

Open each day's process chain and check the run times of your steps and note everything in a excel sheet. Repeat the same for all 7 days. Then you ill get a clear picture on Why the same steps are consuming longer times.

Do you have sufficient BGDs? Idocs are getting generated properly or not..?

Note: Every issue in BW requires a deep analysis.

Regards,

Suman

[Former Member]

Hi Ramesh,

You may have checked difference in number of records and activities PC does when it it takes more time..

Regards,

Ganesh

[Former Member]

Hi Suman

Thanks for ur reply and suggestion

Regards

Ramesh kumar