Brian Jacob Sanchez

Performance Optimization

From hours to seconds — measurable wins

Diagnose and fix slow ABAP programs, expensive SQL, and HANA query bottlenecks.

Service overview

SAP ABAP performance optimization focused on the programs, jobs and interfaces that actually hurt: month-end runs, long-running background jobs and expensive database operations.

Analysis is measurement-led using SAT, ST05, SQLM and HANA plan analysis, so every change is tied to a recorded before-and-after runtime rather than a general recommendation.

Rewrites follow HANA-friendly patterns: pushing logic down through Open SQL, CDS views and AMDP where appropriate, and removing nested selects and unnecessary internal table processing.

Problems this service addresses

  • Slow ABAP programs and long-running background jobs
  • Expensive database operations and nested SELECT patterns
  • Reports that no longer fit the batch window after an S/4HANA move
  • Interfaces timing out under production volumes
  • No baseline measurement to prove whether a change helped

Who this is for

  • SAP technical leads
  • Internal SAP development teams
  • SAP program managers under go-live pressure
  • Organizations that recently moved to SAP HANA

Scope and deliverables

Scope of work

  • SQL trace & ST05 analysis
  • HANA-friendly rewrites
  • Open SQL / CDS optimization
  • Background job tuning

Deliverables

  • Before/after metrics
  • Optimized objects
  • Runtime analysis report

Technologies and capabilities

  • SAP ABAP
  • SAP HANA
  • SQL performance analysis
  • SAT
  • ST05
  • SQLM
  • Open SQL
  • CDS views
  • AMDP
  • Eclipse ADT

Engagement approach

  1. 1

    Discovery and access review

    Short qualification call, confirmation of scope, systems, releases and the technical access required.

  2. 2

    Technical assessment

    Hands-on analysis in your system using ADT, ATC, trace and analysis tools relevant to the scope.

  3. 3

    Findings and prioritization

    Findings written up with severity, effort indication and a prioritized backlog agreed with your team.

  4. 4

    Implementation or remediation

    Agreed changes implemented in transports, with code review against your standards.

  5. 5

    Testing and knowledge transfer

    Testing evidence handed over plus a walkthrough session so your team can continue the work.

Expected outcomes

  • May reduce runtime of the analysed objects
  • Helps identify performance bottlenecks with recorded evidence
  • Improves maintainability of rewritten data access logic
  • Supports capacity planning with before-and-after measurements

Outcomes depend on system landscape, code base and available access — no fixed results are guaranteed.

Related proof and reading

See more anonymized SAP engagement case studies, SAP technical articles on ABAP and S/4HANA, or read about Brian Jacob Sanchez's SAP experience.

Frequently asked questions

Book a technical assessment

Talk through your performance optimization requirement with Brian Jacob Sanchez in a free 30-minute technical conversation.

Book a technical assessment