Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Performance issue after EHP5

Former Member

‎2012 Sep 21 7:12 PM

0 Likes
1,156

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.

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.

Reply
6 REPLIES 6
Read only

Former Member

‎2012 Sep 22 5:24 AM

0 Likes
1,126

post ur select statements

Read only

Former Member
In response to Former Member

‎2012 Sep 22 3:55 PM

0 Likes
1,126

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.

Read only

prakashjasti
Contributor

‎2012 Sep 22 6:47 AM

0 Likes
1,126

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.

Prakash J
Read only

Former Member
In response to prakashjasti

‎2012 Sep 22 3:57 PM

0 Likes
1,126

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    

Read only

Former Member

‎2012 Oct 06 1:47 AM

0 Likes
1,126

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

Read only

RaymondGiuseppi
Active Contributor

‎2012 Oct 06 9:54 AM

0 Likes
1,126

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