D365 CRM Email Storage

(0) Share

Report

Posted on by lance9999

CX has a problem currently with the size of our D365 CRM DB (146GB). It’s growing at a rate of 5-10GB per month. Upon investigation, we can see the biggest culprit is the Email Table which accounts for approx. 60% of the overall database.

When drilling down into the Email table we can see that the Description field (email body) is the leading cause for such a big Email Table. CX currently uses an MSCRM-Add-on attachment extractor that moves all email attachments to Blob storage and strips out the email signature images and wondered if there was anything we could do for the email body (Description).

The emails will still need to be accessible by end users where they can see the email body and attachments to be able to work and resolve a case.