Some of the transactions are taking more time from DB side

[Sandra_Rossi]

Search the answers in the forum. You should have a good knowledge, so it will take you time to learn how to analyze performance issues.

[Sriram2009]

Hi 

1. Since it is Z-transaction, you have to enable the trace using the transaction code ST12 to find the expensive SQL statements based on the requirements you have to add the indexes in the z tables for this you can get help from Abaper and basis guys.

Refer to the link on how to enable the ST12 trace

https://community.sap.com/t5/application-development-blog-posts/st12-trace-step-by-step-instruction-...

2. Have you checked the memory buffer values? using the transaction code ST02

Regards

SS

[Sandra_Rossi]

ST12 is not the only way to analyze performance. You have also the more simple ones SAT (supersedes SE30) and ST05. The main issue is to interpret the results of the trace.

[Sriram2009]

Hi Sandra, he said that some of the transactions are taking more time in the DB, in that case, some of the Z-transactions may not have the proper indexes, for that you have to enable the trace using the transaction code ST12. Regards

[Sandra_Rossi]

As I said, ST12 = ST05 (SQL trace) + SAT (SE30). SAT also measures the SQL performance, but what you mean is that only the SQL trace (ST05 or ST12 as you like it a lot) shows the execution plan. But to interpret it, you must get experienced with database systems.

[Sriram2009]

Hi Sandra Check this SAP note 2524975 Performance tracing overview: SAT, ST05 & ST12 traces

[Sandra_Rossi]

LOL the answer is in the image you have posted:

"If these applications need to be tuned, you can use the Guided Self Service Performance Optimization or contact SAP for further support."

Or search the answers in the forum. You should have a good knowledge to tune the applications, it will take you time to learn.

NB: please paste the image directly in your question, don't create an hyperlink, e.g.: