Dynamics 365 Business Central: How to check tenant size, environment size, company size and table size (Database storage)

Hi, Readers.
Today I would like to talk about a simple topic, how to check tenant size, environment size, company size and table size.

By default, Business Central customers can use up to 80 GB plus an allowance per licensed Essentials or Premium user of database storage capacity. This storage capacity is shared, meaning that the sum of capacity usage across all environments in a tenant must not exceed the limit. If a tenant exceeds this limit, Microsoft restricts administrative actions that create additional environments. Exceeding the storage limit will not interrupt transaction processing within the existing environments. More details: What happens when the capacity limit is exceeded (Exceeding capacity quota)

Some businesses have unique scenarios that may require additional storage. For those organizations that need more space, there’s an option to purchase extra database capacity.
More details: Announcing: Dynamics 365 Business Central database capacity changes as of July 1, 2021

Additional capacity:

Table and database sizes have a significant impact on the performance of Business Central online. Therefore, it is very important to manage the capacity in tenant.
PS: Understanding the Infrastructure of Business Central Online

Tenant size & Environment size

To help our customers manage and plan their storage costs on an ongoing basis, the Business Central administration center includes the Capacity page.

The Capacity page provides an overview of the total database storage usage, with details about the storage used by every environment.

Tenant size:

Environment size:

PS: Dynamics 365 Business Central mini tips: The required roles/permissions to access Business Central Admin Center

Company size

In Business Central, administrators can handle Company size with Data Administration page.

Enter Data Administration in tell me, and then choose the related link.

Choose Refresh

Then you can find the capacity of all companies in the Company Size group.

More details: Dynamics 365 Business Central: Data cleanup tasks page (Data Administration page)

PS: As of now, Company Size cannot be obtained from the code.

More details: Dynamics 365 Business Central: Can we access the standard internal table/field (Access Property = Internal) via AL???

Table size

There are two functions to check the table size in Business Central. The first one is the same as Company Size.

Enter Data Administration in tell me, and then choose the related link

Choose Refresh

Then you can find the capacity of all tables in the Table Size group.

The second method is to view it through Table Information.

Enter Table Information in tell me, and then choose the related link.

The 8700 Table Information page provides information about the number of records in all system and business tables in Business Central, and how much data each table contains.

This information is useful for troubleshooting performance problems, because let’s you see the distribution of data size across tables.

Note
The Table Information page shows data and index sizes, and the sum of table sizes will not match the total capacity used, because it displays the data size, not the actual allocated size. Allocated space is always larger than used space to avoid having to allocate space on every insert, which would limit performance significantly

Very simple, give it a try!!!😁

END

Hope this will help.

Thanks for reading.

ZHU