General problem of performance

[Former Member]

Hi experts,

It seems, from february the ABAP system, the performance, in general, was very poor.

We do some checks, like:

- query in sqlplus: select rsnum from sapsr3.resb where mandt = '200' and werks = '1001' and xloek = ' ' and kzear = ' ' and bdter between '20120901' and '20120930'; The time is around 0,093seconds

- same query, in a custom program (ZKPP_RESB) only for check the time... is 6-7seconds. How it is possible the difference?

We check it in other customers with same query and similar quantity of data, and the time was around 0 seconds in both case (query in sqlplus and with the custom program).

I have the same problem in development and productive.

We try to check an older kernel, and the last kernel, and the result is the same. I update to Oracle 12c... and nothing.

Thanks in advance,

Regards,

[yakcinar · Accepted solution]

Hello Victor,

You can activate SQL trace and see where does the query spend time?

Does it run about 6-7 seconds for scond, third runtime?

Did you check it using SQL Editor in DBACOCKPIT transaction? How does it behave?

Regards,

Yuksel AKCINAR

[Former Member · Accepted solution]

Hi Victor,

Enable the Sql trace in ST05 or ST12 for performance trace and do check the sql queries execution plan and see if there is any index defined for the query.

Also you can check STAD for the user and get the durations where the most time is spent when the transaction is ran.

If not you can create on customized index on the fields which are in the query and optimize the query.

If there exists a index, you can reorg the tables and indexs for optimization.

Refer below blog for steps:-

http://beingsyednasir.blogspot.in/2013/11/sql-trace-analysis-in-sap.html

Do let us know if you need further inputs.

Regards,

Ram