Data growth remains one of the top challenges of SAP systems administrators. Our experience in working with various SAP environments shows that even up to 25% of your system can be polluted with temporary data, that is automatically generated data that quickly loses its value. That’s why it is so important to regularly perform housekeeping activities not only in your production system, but also throughout your SAP landscape.
1. Automate housekeeping
Let’s face it, no on enjoys housekeeping. It is often perceived as a low value, time-consuming tasks. But if neglected, it leads to long-term consequences of cluttering your database and adding to storage costs. The best solution is to automate it using available tools – automation will ensure greater precision and speed.
2. Set up the best archiving strategy
Common practice is to put old data into an archive – but old doesn’t necessarily mean useless. Before you decide on archiving data, classify it according to its importance. Check which data is “hot” (frequently used) and which is “cold” (e.g. stored due to legal requirements, but not accessed often). Define your archiving rules accordingly, choose your storage, and automate as much as you can. We recommend to store cold SAP data in affordable and easy to extend data lakes.
3. Introduce end-to-end lean data management
Don’t focus on housekeeping only – your SAP landscape requires more than that to run at its top performance. Start with an in-depth analysis and benchmark your system against peers, then check which data is most important to your users. Knowing this, you will be able to devise and adopt the best lean data management strategy for your systems.