Announcements
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?
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/
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:
Prodsystem:
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
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.
Hello,
Do you have integration enabled in your production? I bet it could be the email entity.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156