SAP Knowledge Base Article - Preview

2247652 - Identify expensive sql statements in an ABAP environment

Symptom

The business functions give a result only after an unusual high wait time. The reproduction steps of this performance problem are known. There is a hint, that most of the time is spent on the database. It should be clarified which sql statements are responsible for the wait.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • Any Database version
  • Any SAP NetWeaver Application Server ABAP version

Keywords

ST05, sql trace, performance analysis, sql tuning, bind variables, native sql, ABAP , KBA , BC-DB-SDB , MaxDB , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.