topic Re: Performance issue after EHP5 in Application Development and Automation Discussions

Performance issue after EHP5

Former Member — Fri, 21 Sep 2012 18:12:13 GMT

We upgraded to EHP5.

The Z program fetching data from BKPF, BSAK and BSIK is taking triple the time after upgrade.

We have a system with pre upgrade production and the same job runs for 30 mins where as post upgrade production is around 90 minutes.

Any idea what we could do to identify?

We have 5 standard secondary index and one custom which came with the sap note: 194842.

All index are active in both the systems and everything looks identical.

Basis just pushing on ABAP so no help.

Would appreciate your help.

Re: Performance issue after EHP5

Former Member — Sat, 22 Sep 2012 04:24:06 GMT

post ur select statements

Re: Performance issue after EHP5

prakashjasti — Sat, 22 Sep 2012 05:47:08 GMT

Hi,

I think there were some indexes created on those tables for fetching the data from those tables

were missing after your upgrade.

Please check the indexes of those tables in your old system.

Regards,

Prakash.

Re: Performance issue after EHP5

Former Member — Sat, 22 Sep 2012 14:55:37 GMT

Abhishek, Thanks but my question is why is the huge difference in 2 systems.

If selects are poor and data is huge, the performace should be poor in both pre and post upgrade.

Re: Performance issue after EHP5

Former Member — Sat, 22 Sep 2012 14:57:07 GMT

Hi Prakash,

The indexes are checked in BSAK, BSIK, BKPF and look same in both.

I am not sure if anything manually required to be carried out after upgrade.

I adjusted all 3 table indexes in SE14 but no use.

Thanks

Re: Performance issue after EHP5

Former Member — Sat, 06 Oct 2012 00:47:51 GMT

What system did you upgrade from? If your upgrade was from a non-unicode to a unicode version, then keep in mind that storage requirement is now double (so the data you are extracting is double the size it used to be).

Re: Performance issue after EHP5

RaymondGiuseppi — Sat, 06 Oct 2012 08:54:55 GMT

Did you compare execution plans between both systems. What is your database, check if some parameters have changed like statistics in Oracle or other tools used by SQL optimization. Also do both system execute on similar actual system (CPU, I/O resources) with similar load tnumber of concurrent user, tasks, etc.)

Regards,

Raymond