Performance issue after EHP5

[Former Member]

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.

[Former Member]

post ur select statements

[Former Member]

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.

[prakashjasti]

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.

[Former Member]

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    

[Former Member]

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).

[RaymondGiuseppi]

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