How to Reduce Database Storage on SAP Commerce Cloud

[YannickRobin]

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

https://sapvideoa35699dc5.hana.ondemand.com/?entry_id=1_utqo9r1o

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!