Performance analysis of the entire SAP database infrastructure

How we could reduce the resource requirements of databases with increased performance

Task

Our challenge

One of our customers needed support in the performance analysis of the entire SAP database infrastructure, as well as the development of recommendations for action.

In detail

Our success story

Our customer (retail, 10,000 employees) operates a very large database infrastructure. Due to the historical growth of the infrastructure, there were repeated performance losses in the past. For this purpose, a PaPCore┬ę project was started to analyze each individual SAP database. In a previously defined standardized procedure, the databases were examined and the analysis results were evaluated by our PaPCore┬ę team and optimization measures for improving performance were defined. We chose the same procedure for analyzing the ABAP code. Finally, we evaluated the optimization measures in terms of their impact on the performance to be achieved.

As a result of the project, the resource requirements per database were significantly reduced while performance was increased. In addition, failures due to overload were reduced in the medium and long term through preventive optimization. Indirect effects were the acceleration of service restores after acute performance drops with subsequent initiation of RCA and long-term improvement measures, as well as an accelerated throughput of transactions per time to shorten process runtimes.

About wescaleIT

wescaleIT AG is an IT full service provider specializing in the planning and implementation of demanding IT and technology projects. We focus on the wishes, needs and hardships of our customers, with an additional focus on optimizing their economic success.

The digitalization of global resources, in combination with our PaPCore┬ę system and our unique wealth of experience in the global IT environment, make us an unbeatable partner for your business.
This novel concept enables us to offer you the possibility to master the challenges of digital transformation in a transparent, scalable and high-margin way. Whether it’s employee leasing, ensuring delivery capability, a shortage of skilled workers or demographic change – we have solutions.

More success stories

Process management and optimization in infrastructure management

How we were able to sustainably reduce orders in hardware management

zum Case

Design and development of a SAP workflow application

How we developed a SAP workflow application

zum Case

Cloudification

How we provided a platform to ensure operational excellence

zum Case