Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Advise on how to reduce ActivityPointerBase

(0) ShareShare
ReportReport
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,964 Super User 2024 Season 1 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans