The table grows ActivityPointerBase grows overdimensionally fast.

(0) Share

Report

Posted on by Community Member 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:

Performance

All responses (5)

Answers (0)

Suggested answer

Arjan ter Heegde 37 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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:

Prodsystem:
Suggested answer

a33ik 84,321 Most Valuable Professional on at

Like (1)

Report

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 Microsoft Employee on at

Like (0)

Report

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 84,321 Most Valuable Professional on at

Like (1)

Report

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.