SAP HANA/SQL performance optimisation
Better performance through faster SQL data queries – this cannot be taken for granted even with the SAP HANA database. With this “Consulting in a Box” offer, our experienced consultants take a close look at your SAP HANA database and analyse it for vulnerabilities in terms of long-runners, expensive SQL statements, DB parameters, data growth, misconfigurations and much more.
We analyse both directly and indirectly affected components. Directly affected components are such aspects as DB configuration, DB indices and index design as well as ABAP programs. Indirectly affected components include virtualisation, cloud platforms or even the operating system. In addition, we consult with you to agree on measures and procedures for optimisation in order to achieve the best possible results.
Your benefits
- Perfect configuration - ideal parameterisation of SAP HANA and the SAP landscape
- Performance - improving SAP HANA performance by tuning expensive SQL statements and long-runners
- Savings – by optimising expensive statements, you save hardware (CPU and memory) and valuable time (shorter user dialogue response times).
Roadmap
-
Analysis of the current situation
-
Development of recommendations
-
Optimisation of the systems
-
Improved performance
SAP HANA/SQL performance optimisation
Our services
- Parameter and configuration recommendations for the SAP HANA DB, OS, VM or cloud platform
- Recommendations for optimising expensive SQL statements (e.g. DB indices) and long-runners (critical points in ABAP programs)
- Success check after implementing the recommendations
Objective
- SQL and performance analysis of the SAP HANA database
- Recommendations for the parameterisation of the SAP HANA database
- Recommendations for optimising the SAP landscape
- Schedule and dependencies for the optimisations