Skip to main content

Notifications

Community site session details

Community site session details

Session Id : r496nct/Rax1IeoOxrEXOm
Power Apps - Microsoft Dataverse
Unanswered

Dataverse - system tables takes much more space than they should.

Like (0) ShareShare
ReportReport
Posted on 23 May 2024 09:19:02 by

Hello, 

i have problem with different behaviour on Power Apps. I got Dataverse Storage Capacity alert of less than 15% capacity is available, which led me to investigate the Database usage. I found out that there are 2 environments, DEV and TEST. The DEV takes 1.45GB of database, while TEST environent takes almost 2.5x more space - 3.6GB. 

Dzaro_0-1716455457553.png

I double checked the table storage for the tested tables and applications, there are 10 tables being used, which the count of the records in every one of them doesn`t exceed 1500 records. 

 

In deeper look, most of the space is taken by system tables. Screens below

DEV Environment:

Dzaro_1-1716455602306.png

Dzaro_2-1716455618862.png

In addition, there is only one custom solution being developed and tested, which icludes Power Pages. There are the same solutions provisioned on both envrionments with translation in 3 languages enabled in each of them. I can understand difference in 10-15% more space, but 2.5x more space with the same solutions? Something weird happened there and i can`t find out what. Someone had similir issue or has any advice to find the solution to solve this? Recreating TEST envrionment (deleting and creating) is the last option if nothing else helps.

 

Categories:
  • MichaelFP Profile Picture
    1,831 Super User 2025 Season 1 on 24 May 2024 at 19:03:24
    Re: Dataverse - system tables takes much more space than they should.

    I recommend to open a ticket with Microsoft request to clean up your environments with old data and old components that are not used anymore in you organization. This is something that is not done automatically.

    I had the same situation and was able to clean up 15GB in 7 environments.

     

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 9

#2
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics