performance issue after upgradation

[Former Member]

Dear All,

I am facing one problem, we have upgraded the existing 4.6c version to ecc 6.0 version for one of the client. And from the basis side everything is completed. But while I tried to run the z-programs in the new version i.e ecc 6.0 version it is taking long time than usual in 4.6c version. On observing the coding , the coding contains innerjoins of 4 to 5 cluster tables. Is this could be one of the reason for longtime execution or else any other reason is there. Do we need to performance tune the programs or else is there any procedure to reduce the program execution time without optimising the code.

Please help me and thankful to you all in advance

Regards

Rayasam

[Former Member]

Things that work before the upgrade should work after (generally). I'd look at the basis settings.

Rob

[Former Member]

Hi Bob,

After upgradation things are not well i.e still the z-programs are taking longer time for execution.

Please help me in this case.

regards

rayasam

[Former Member]

Like I said - make sure the basis settings are correct. I can't help you with those.

You can use transaction ST05 to help analyze problems with database access.

Rob

[Former Member]

Did you delete the SQL packages on your system after doing the upgrade?

The existing SQL packages may no longer be appropriate, and may not be allowing the correct optimizations to occur.

Normally, the SQL packages will be deleted as a matter of course during the upgrade, but if it didn't happen for some reason, it can affect performance.

See the following, which discusses this issue:

<a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/ff/ff6dcb409f11d1896b0000e8322d00/content.htm">SQL Package Handling</a>

Also, even if the SQL package were deleted and rebuilt, it may take some time for the system to optimize with the new packages.

Good luck

Brian

Fix typo

Message was edited by:

Brian Sammond