Announcements
We are trying to find a solution on how we can reduce the data in ActivtyPointerBase. Purging all unnecessary email/activity had been done but did not do much in our overall Database Capacity.
Maybe someone can help or explain on how to fix it. Thank you!
This article is used as guidance: [Customer Guide] How to Reduce ActivityPointerBase - Dynamics 365 General Forum Community Forum
Have you run the reports in the article to identify which activities are using most space and confirmed that it is email?
I have encountered this in the past where a mailbox was configured to sync everything server side and the user frequently sent or received emails with excel/word documents attached.
The solution was to use migrate those emails to SharePoint or Azure blob storage.
There are a number of third party solutions to do just that, such as:
Hi,
The typical culprit of ActivityPointer bloat is the Description column. For Email activities in particular, the email body is stored in this column which can very quickly eat up storage at higher volumes
powerusers.microsoft.com/.../1532112
You can also raise support ticket with Microsoft for recommendations
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156