Search This Blog

Sunday, January 15, 2023

GET THE SIZE OF TABLES IN DYNAMICS 365 / DATAVERSE ENVIRONMENT

Data size is continuously growing over the time. Thus, data storage and usage with the increasing complexity and new supported data types, is becoming an essential tool for the organizations to be able to expand their business.


Therefore, knowing the data volume becomes very critical and in Dataverse, you are able to check the space reserved by each table.

In this post, we will see how to get the size of Dynamics 365 / Dataverse tables for an environment.

Using the Capacity page in the Power Platform Admin Center, you can get the size of each table (in MB).
  1. Login to Power Platform admin Center
  2. Under the Resources menu, click the Capacity option
    Tables size 1

  3. Select the Dataverse tab, or click on the Trial tab to check the environments
    Tables size 2

  4. Click the Details (graph) button for the specific environment to open a detailed report of Usages for Database Usage, File Usage, and Log Usage
    Tables size 6

  5. To check the size of each table, from the Top database capacity use, by table section, click the burger menu > Download all tables option
    Tables size 3

  6. A CSV file will be downloaded where you can check the size for each table sorted by the highest space usage in MB
    Tables size 7

  7. This report can give you some insights in case you are facing some performance issues in your environment where it might be related to the tables size

No comments:

Post a Comment