web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Find out what consumes...
Power Apps
Suggested Answer

Find out what consumes so much data in Dataverse

(1) ShareShare
ReportReport
Posted on by 6
I got DEV and PROD environments in dataverse. But even if there should be nearly none data except a few dozen test records, the DEV environment got nearly the same size as PROD.
 
 
I tried to find out, but the overviews are not really helpful so far. Neither do I find any of these tables, nor a good explanation of what those are and how you could clean them.
 
Here is the table data consumption overview from the dashboard:
 
Even querying the whole db using MSSMS did not help as I found no tables that are really large.
 
Is there a way to investigate the data consumption further?
It seems to increase a 100 MB every week, but the active tables do not really grow that much (e.g. the contacts table only got a few dozen new records every week).
Or would it be meaningful to contact the microsoft support for this?
 
Thanks for your help.
I have the same question (0)
  • Suggested answer
    Daniel Bocklandt Profile Picture
    5,151 Super User 2026 Season 1 on at
     
     
    In my opinion the most reliable way. 
     

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

     
  • MS.Ragavendar Profile Picture
    6,372 Super User 2026 Season 1 on at
     
    By connecting like this can we able to perform delete queries for a larger dataset as well?
  • Daniel Bocklandt Profile Picture
    5,151 Super User 2026 Season 1 on at
     
    With SQL Server Management Studio (SSMS) you can't delete data directly since the connection is read only. 
     
    But with the information from this step, it iseasily possible to delete the data with the XRMToolBox (Bulk Data Updater). 
    You can load them as fetch xml and delete them from there.
     
    But since the SSMS shows you all the tables you have to be carefull about the datasets you're deleting, since system required datasets are also displayed by this method. 

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

  • Gabriel Weidmann Profile Picture
    6 on at
    Ok, so for the first step I have used Fast Record Counter  Â· XrmToolBox to fetch the sizes of all the tables; way more easy than with sql server.
     
    Now I will check if I find anything useful about those tables. The hard part will be identifying which data I can safely delete and which relations I should also delete.
     
  • Suggested answer
    Daniel Bocklandt Profile Picture
    5,151 Super User 2026 Season 1 on at
     
    if you want to be 100% sure what you can safely delete and what absolutely shouldn't be touched, I strongly recommend working with Solutions.

    The idea is simple:
    Add all your apps and flows into a solution (one by one), and then include the required components.
     

    Once you've done that, every table that appears inside the solution is safe to work with, including deleting records if needed.

    All the other tables are most likely system tables, which contain data your environment needs to function properly. Deleting anything there can break a lot (and sometimes silently).

    To be extra safe, export the solution as unmanaged first, so you have a backup.
     
    One more thing:
    Be careful when deleting relationships. That can lead to unexpected side effects or break dependencies you weren't aware of.
     

    If this solved your problem, please mark it as Solved to help others find the solution faster.
    If you found it helpful, consider giving it a Like to support each other in this community!

    Thanks, and happy building!

  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    Just to say, your DEV if its a real DEV environment is of course free and you cannot add capacity too it.
     
    Now to answer your question.
     
    In the Admin Center
    -Click on Licensing
    -Click on Dataverse (to start)
     
    An image of our usage first) based on overall 
     
    now scroll down a little on same screen
     
    Now click see all environments at the bottom
     
    Now click on any environment, i'll pick The Gernaey Code. While it all says its within capacity let's take a look
     
    Now you are on the Database usage by default, so scroll the screen down and you will see all storage tables and what they are doing.
    FYI, Copilot takes a lot, there are other Trials that take A LOT.
     
     
    Now scroll back up and click File and Log
    When I click File and scroll down I see explaining how much space each table/resource type is taking
     
    Same for log
    You can further click on a link like WebResourceBase and get this
     
    This will all show you where your data is being used. Now you will have to look across your solutions, what you installed (your own solutions + trials + purchased + Microsoft Free / CAT etc, people installing Sample Solutions etc.
     
    And you will see what is doing what.
     
    On the same screen at the top click Manage Capacity and validate what you assigned to it, validate what you set for Pull from Tenant Capacity etc
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey
  • Gabriel Weidmann Profile Picture
    6 on at
    Thank you, that's really a better overview
     
    Just to say, your DEV if its a real DEV environment is of course free and you cannot add capacity too it.
     
    Not sure what you mean. Currently my DEV counts to my total, I never noticed an option for a "free DEV" (sorry that everything is in german; I have not found a way to turn PPAC to english, even if my profile is and every setting I found).
     
     
    When analyzing the page, I have seen a large leap in Copilot (?) storage usage.
     
     
    I have disabled this on my dev environment and if it does not produce problems, I will disable this on PROD to hopefully save the 650 mb.
     
     
    But in other tables I see an slow increase in storage usage, too, e.g.
     
     
    I'm really not doing much on PROD in terms of new views, processes, ... So I don't really get where this could come from.
     
     
    Furthermore I have compared table sizes though and discovered an increase in the fileattachment table:
     
    Here are the top 20 days of increase:
     
    File storage is fortunately not the problem at the moment, but I guess that it also will increase the table size for storing all of these handles.
     
    The weird thing is that these thens of thousands of entries all look the same:
     
     
    All "Untitled.txt", "objectid 9333" seems to mean "Web Resource", even if no on has touched them for ages, so the increase makes no sense.
     
     
     
    A general question: Are there trainings to learn about all of this stuff? Or is this something you need to figure out by yourself hands on?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 556

#2
WarrenBelz Profile Picture

WarrenBelz 412 Most Valuable Professional

#3
Haque Profile Picture

Haque 296

Last 30 days Overall leaderboard