Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

The table grows ActivityPointerBase grows overdimensionally fast.

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?

Categories:
  • 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,321 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,321 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

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,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans