Applies to Product -Dynamics 365 Lifecycle Services
What’s happening?
The MRDB size is growing exponentially, consuming all storage in the Finance and Operations environments, including both Production and various Pre-Prod environments.
Reason:
The MRDB table plays a significant role in managing data storage by maintaining relationships between various entities in the system. As the Dynamics 365 environment grows and accumulates more records, the MRDB table expands to accommodate the increasing complexity of relationships. This growth can be exacerbated by frequent database refreshes from Production to other environments, which may replicate unnecessary data.
Resolution:
- Regularly clean up unnecessary or outdated records in the MRDB table.
- Optimize the data model by removing unused relationships.
- Monitor the growth of the MRDB table and consider increasing storage capacity if needed.
- Implement a cleanup routine for the MRDB table, particularly for tables like JournalTrans, which can be managed through the out-of-the-box (OOB) cleaning job.
- Schedule a batch job to delete document history records that have reached the end of their retention period.
- Set up a cleaning task for Batch History on the production environment, which is included in the Managed Service list of jobs.
- Consider reducing the retention period for document history to manage storage consumption effectively.
- For environments that do not utilize Financial Reporter, assess the possibility of cleaning the MRDB tables to free up space.