Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

The table grows ActivityPointerBase grows overdimensionally fast.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

The table grows ActivityPointerBase grows overdimensionally fast. In the production environment, the table consumes almost 2 GB more memory than in the test environment.
The test environment was also recently copied from the production environment, which means the environments should be at about the same level.


Test environment: 2,027,453 records
14.624 MB
Production environment: 2,051,935 records
16,607 MB

Assuming the test environment, however, 1 GB of data should only come about with 2,027,453/14.6 = approx. 140,000 more data records.

While according to the current state even 2 GB more is used for only 24,482 records.

Even more curious is the case that only 2,700 records have been added recently and for that about 1 GB of storage space has been added.

Why is the table growing so much in memory even though so few new records have been added?

  • Suggested answer
    Arjan ter Heegde Profile Picture
    Arjan ter Heegde 37 on at
    RE: The table grows ActivityPointerBase grows overdimensionally fast.

    Emails in Dataverse are now stored in blob storage. See my blog for more information:

    https://arjanterheegde.nl/2023/06/12/emails-in-dataverse-are-now-stored-in-blob-storage/

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The table grows ActivityPointerBase grows overdimensionally fast.

    E-Mail Integration is enabled in both Systems, so it should be the same for the systems.

    I checked the size of the ActivityPointerBase in the capacity section of the power platform admin center  this is where i got my data from.

    Testsystem:

    pastedimage1642155492788v1.png

    Prodsystem:

    pastedimage1642155550613v2.png

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: The table grows ActivityPointerBase grows overdimensionally fast.

    I'm sorry for the confusion. I missed the word 'E-Mail' when I replied. Do you have email integration enabled in your instance? I would recommend to check the capacity in your power platform admin center - docs.microsoft.com/.../capacity-storage

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The table grows ActivityPointerBase grows overdimensionally fast.

    Sorry, I don't know what you mean by integration.

    However, I noticed something else strange.

    As you already guessed, quite a few e-mails were added on the one day with the large increase. After another day the storage space has been reduced from the original 1 GB additional storage to 500 MB additional storage.

  • a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: The table grows ActivityPointerBase grows overdimensionally fast.

    Hello,

    Do you have integration enabled in your production? I bet it could be the email entity.

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

Featured topics

Product updates

Dynamics 365 release plans