Technical Articles
How to Reduce Database Storage on SAP Commerce Cloud
As part of our vlog series dedicated to Performance Optimisation Best Practices for SAP Commerce Cloud, we release our third video.
In addition to physical and contractual limits of data storage, large tables have an impact on query response time and database scalability.
In this session, you’ll learn how to reduce database storage on your SAP Commerce Cloud environment.
In this video, I will show:
- How to check the Storage Usage of your database
- How to identify the Top Tables consuming storage in your database
- How to setup job for Regular Clean-up
- What are the Most Common Largest Tables into your database
You can find here the deck supporting this session.
Here are the links mentioned in the video:
- SAP Help Page Data Retention Framework
- Sanecleanup open source tool: https://github.com/sap-commerce-tools/sanecleanup
- CX Works Article Data Maintenance and Cleanup
- SAP Notes for storedhttpsessions cleanup: https://launchpad.support.sap.com/#/notes/2826384
- Clean-up Cronjob Logs, see Data Maintenance and Cleanup > Technical Data > Cronjob Logs
- Clean-up ImpEx Media, see Data Maintenance and cleanup – ImpexMedia > Technical Data > ImpEx Media
Stay tuned for more updates and tips from our experts in the coming weeks!
Thanks for sharing.
Unfortunately the links to CX Works articles do not work anymore. Could you please help find the relevant content?
Correct. CX Works is sunset since end of June. Let me check what is the new link.
I asked the author to put the article in SAP Blog and changed the links! Now this is pointing to https://blogs.sap.com/2023/09/20/data-maintenance-and-cleanup-of-a-sap-commerce-cloud-project/
Luckily, the content has been indexed by Web Archive: https://web.archive.org/web/20230520105915/https://www.sap.com/cxworks/article/2589633933/data_maintenance_and_cleanup