XaviC
4 hours agoNew Contributor III
Database space control policies
Hi!
We are trying to control the size increase in our production application. We know the growth comes from:
- Stage tables that allow users to drill down and back onto source data.
- Data records
- Audit tables (they can grow a lots if they are recording continuous changes to rules, data for example)
- Logs which will impact Framework database growth (task activity and error logs, will vary depending on the detail login set in BR, DM and on the system configuration as well as your retention policy)
- Load transactional data, which will increate your data units and data records unnececarily, which BIBlend should be used for this type of data load instead of loading it to the finance cube.
We have analyzed it and we realized the StageAttributeTable and other stage tables has a significant size. Has ayone performed databse maintenance by deleting data from the stage tables? Is it possible to do that while keeping the cube data intact and workflows completed?
Any ideas or best practices regarding database maintenance would be very welcome.
Regards,
Xavi