Skip to content
IT Canvass
Menu
ServiceNow
SailPoint
SAP
TutorialsContact
SAP best practices · Lesson

Optimization

Quick answer

Optimization keeps a growing system fast and cost-effective.

Key takeaways

  • Measure first (ST03, ST05, HANA plan analysis) before optimising.
  • Fix the biggest bottlenecks (usually custom SQL/code) first.
  • Push logic to the database (CDS/Open SQL) on HANA (code-to-data).
  • Watch out: Skipping the discipline under delivery pressure.

Key practices

  • Measure first (ST03, ST05, HANA plan analysis) before optimising.
  • Fix the biggest bottlenecks (usually custom SQL/code) first.
  • Push logic to the database (CDS/Open SQL) on HANA (code-to-data).
  • Partition heavy jobs; schedule batch off-peak.
  • Right-size resources; archive old data to control volume.

Why it matters

Optimization keeps a growing system fast and cost-effective. The golden rule is measure-then-optimise: target the real bottleneck, change one thing, and re-measure. Blind tuning wastes effort and can make things worse.

Common pitfalls

  • Skipping the discipline under delivery pressure.
  • Not documenting decisions.
  • Ignoring the clean-core principle.

Want to learn this properly?

Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.

See the courseAsk a question

Check your understanding

  1. Which statement is true of Optimization?

    • A. Tiles are the clickable entry points on the Fiori launchpad that launch apps, and can display live…
    • B. Troubleshooting FI focuses on the recurring issues in financial postings and processes, posting errors…
    • C. The golden rule is measure-then-optimise: target the real bottleneck, change one thing, and re-measure.
    Show answer

    C. The golden rule is measure-then-optimise: target the real bottleneck, change one thing, and re-measure.

    Covered in the “Why it matters” section of this lesson.

  2. Which of these also applies to Optimization?

    • A. Over-privileged HANA users (e.g. broad system privileges).
    • B. Blind tuning wastes effort and can make things worse.
    • C. Wrong logical-system assignment (esp. after system copy).
    Show answer

    B. Blind tuning wastes effort and can make things worse.

    Covered in the “Why it matters” section of this lesson.

  3. Which part of the Learn SAP curriculum covers Optimization?

    • A. SAP best practices
    • B. SAP FI
    • C. SAP MM
    Show answer

    A. SAP best practices

    This lesson sits in the SAP best practices section of the Learn SAP course.

Frequently asked questions

What does the term Optimization refer to in SAP?

Optimization best practice is about continuously improving performance, cost and process efficiency, driven by measurement, not guesswork.

What else is worth knowing about Optimization?

Optimization keeps a growing system fast and cost-effective.

What is the practical takeaway on Optimization?

Measure first (ST03, ST05, HANA plan analysis) before optimising. Fix the biggest bottlenecks (usually custom SQL/code) first. Push logic to the database (CDS/Open SQL) on HANA (code-to-data).

What tends to go wrong with Optimization?

Skipping the discipline under delivery pressure. Not documenting decisions. Ignoring the clean-core principle.
CallWhatsAppEnquire