support pact: report execution time

[Former Member]

Hi all,

we have got one report....that report is working perfectly fine in one of our system taking about 2 hrs run time but it taking about 13-14 hrs in our other box where we applied the Support Pack recently...so I was just wondering what may be the possible reson for this:

Can you please tell all the possibilities that I need to check with...

Thanks,

Rajeev

[former_member181995]

Support packages are released for user convince and adding new Functionality and remove short comings, I don't think as support package is causing the performance issue on report. You need to just stick the basics of ABAP like proper indexing and Keys and No Inner loops(As much as possible) and many more.

[Former Member]

Hi amit,

Thanks for ut reply....I just ran that report in the box without SP and it ran again fine there...so I think there is no issues with the way code is written ryt?

[Former Member]

You need to check the code and see what is it doing. Just saying a report is not going to help anyone.

At a start you should run SE30 in both the boxes to see where the bottleneck is in the box with SP applied, and then see if you can find something related to that in OSS.

to give you an example, SAP made some changes to the way it selects data in variant config in oneof the support packs. That caused one of our cusotm reprots to run longer than usual. But then we looked at the analysis to see what happened, found the cause, and applied to resolving note.

No one can help you here if you keep on repeating the question. Support packs can do a whole lot of things. Look at the side effects report for the SP you applied to see if there are any obvious areas related to your report

[former_member181995]

Check The DatabaseHit(ST05) in Both of Boxes.And do Analysis what The impacts are fluctuating compare to both.