Advise on how to reduce ActivityPointerBase

(0) Share

Report

Posted on by Daisy J

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

Categories:

Dynamics 365 Administration

All responses (2)

Answers (0)

Gerry Canning 25 on at

Like (0)

Report

RE: Advise on how to reduce ActivityPointerBase

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:

www.mscrm-addons.com/.../AttachmentExtractor
Suggested answer

Bipin D365 28,962 Moderator on at

Like (0)

Report

RE: Advise on how to reduce ActivityPointerBase

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