Consulting in a Box
SAP HANA/SQL performance optimisation
With this consulting service, our experienced consultants take a close look at your SAP HANA database and analyse it for vulnerabilities.
SAP HANA/SQL performance optimisation
Better performance thanks to faster SQL data queries - this is not a given with the SAP HANA database either. With this "Consulting in a Box" offer, our experienced consultants take a close look at your SAP HANA database and analyse it for weak points 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 DB configuration, DB indices and index design as well as ABAP programmes. Indirectly affected components include virtualisation, cloud platforms and the operating system. We also coordinate optimisation measures and procedures with you in order to achieve the best possible results.
Your benefit
-
Optimal configuration
Ideal parameterization of SAP HANA and the SAP landscape
-
Performance
Improving SAP HANA performance by tuning expensive SQL statements and long-running processes
-
Saving
By optimizing expensive statements, you save hardware (CPU and memory) and valuable time (shorter user response times).
Roadmap
SAP HANA/SQL performance optimisation
Our services
- Parameter and configuration recommendations for the SAP HANA DB, the OS, the VM or the 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 parameterising the SAP HANA database
- Recommendations for optimising the SAP landscape
- Schedule and dependencies for the optimisations