Dynamics Community Forum Thread Details

Importing data from a 14GB SQL DB turns into 160 GB in Dynamics 365, is there way to reduce the size?

We are using Kingswaysoft to move the data into Dynamics. We've used bulk delete to get clean up System Jobs, etc. but that seems to be a drop in the bucket. Is this typical? A lot of it seems to be tied up in Activities and Appointments. Is there a way to compress the data?

Categories:

Dynamics 365 Administration

Other Functionality

Hi,

Greetings!

Please note, each Dynamics 365 entity (table) has additional system fields like Created On, Modified On, Created By, Modified By etc. Because of these additional fields/data, Dynamics 365 database size is greater than the data imported.

Regarding, compression, I am not sure how it impacts the performance.

However, to reduce database size, I would recommend one of the following ways:

Activities include Emails. Attachments with emails are stored as binary data within Activity (Email) table. To reduce the size, you can use Attachment size limit configuration.
Move attachments (documents) to SharePoint or other document storage.
Move Older (completed) Activities / Appointments (or other records) to another Database (with limited or required information) for analytical purpose. Then create Reports to retrieve these records, on demand (from the reporting/analytical DB).

Tweaking D365 Database Configuration (like indexing, compression etc.) may lead to unexpected results. To avoid this, it is recommended to open a ticket with Microsoft or your Partner to get suggestions on DB Configuration and Optimization.

Let me know if you need more clarification.

Best,

Wahaj

(if it helps, please mark it as verified)

Quick Links

Leaderboard