Skip to main content

Notifications

Dynamics 365 general forum
Suggested answer

Advise on how to reduce ActivityPointerBase

Posted on by

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.

pastedimage1666136928294v2.png

pastedimage1666136906122v1.png

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

  • Gerry Canning Profile Picture
    Gerry Canning 25 on at
    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 Profile Picture
    Bipin D365 28,962 Moderator on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans