Performance
Quick answer
On HANA, many traditional bottlenecks vanish, but performance work shifts to pushing logic to the database and avoiding row-by-row processing.
Key takeaways
- ST03 (workload analysis) shows where time is spent, response time broken into database, CPU, wait and other components, by…
- Baseline with ST03, drill to the worst offenders, use SQL trace (ST05) or ABAP runtime analysis (SAT) to find the cause, fix one…
- Buffers (ST02): ensure program and table buffers are well-sized to avoid database hits.
- Watch out: Tuning without measuring (ST03 first).
The workload monitor (ST03)
ST03 (workload analysis) shows where time is spent, response time broken into database, CPU, wait and other components, by transaction and time period. It is the starting point for performance work: it tells you what is slow and why, rather than guessing.
Key tuning areas
- Buffers (ST02): ensure program and table buffers are well-sized to avoid database hits.
- Database (ST04, ST05 SQL trace): find and fix expensive SQL and missing indexes.
- Work processes (SM50/SM66): right mix and enough of each type.
- Custom code: the frequent culprit, SELECTs in loops and the like.
A disciplined method
Baseline with ST03, drill to the worst offenders, use SQL trace (ST05) or ABAP runtime analysis (SAT) to find the cause, fix one thing, re-measure. Most big wins come from fixing bad custom SQL and right-sizing buffers/database.
HANA context
On HANA, many traditional bottlenecks vanish, but performance work shifts to pushing logic to the database and avoiding row-by-row processing. The measure-first principle still rules.
Common pitfalls
- Tuning without measuring (ST03 first).
- Ignoring expensive custom SQL.
- Under-sized buffers hammering the database.
Want to learn this properly?
Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.
Check your understanding
Which statement is true of Performance?
- A. It is the starting point for performance work: it tells you what is slow and why, rather than guessing.
- B. SAP security protects the system and its data through authorizations, secure configuration, monitoring and…
- C. This page collects practical MM examples, the everyday transactions and scenarios that show materials…
Show answer
A. It is the starting point for performance work: it tells you what is slow and why, rather than guessing.
Covered in the “The workload monitor (ST03)” section of this lesson.
Which of these also applies to Performance?
- A. Baseline with ST03, drill to the worst offenders, use SQL trace (ST05) or ABAP runtime analysis (SAT) to find…
- B. Guessing instead of using the reference tools.
- C. Textbook answers without practical grounding.
Show answer
A. Baseline with ST03, drill to the worst offenders, use SQL trace (ST05) or ABAP runtime analysis (SAT) to find…
Covered in the “A disciplined method” section of this lesson.
Which part of the Learn SAP curriculum covers Performance?
- A. SAP administration
- B. SAP ABAP development
- C. SAP TCodes
Show answer
A. SAP administration
This lesson sits in the SAP administration section of the Learn SAP course.