In this post, I would show how I did troubleshooting on a long running job. My investigation found that runtime of the job was mostly spent on reading a SAP table VLKPA. The SQL access path chosen by database to read the table is correct based on then-existing VLKPA index. But the index used is…
Tag Archives: SAP program performance tuning
SAP ST12 Trace – SQL performance analysis
This post is to continue my writing on how to tune a SAP program/application performance based on SAP ST12 traces. My previous post is writing about overall SAP program performance tuning process and how to analyze ST12 ABAP trace for SAP program/application performance tuning. Here, I would cover how to analyze SAP SQL trace to…