Small and medium business | Business Central, N...

Performance Impact on Large Business Central Databases and limitations

(1) Share

Report

Posted on by Nithyan G

Hello everyone,

How much data can an on-premises Business Central instance support without impacting performance, and what are its limitations with respect to the database growth?
I’ve encountered databases larger than 500 GB. As the database continues to grow, will the performance of the system be affected?

I also did not find any document from MS stating the limitations.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 93,222 Super User 2025 Season 2 on at

Like (3)

Report

Performance Impact on Large Business Central Databases and limitations

Hi, Below is some information from the field at this year's BC Tech Days, I hope it can give you some tips.

Thanks.

ZHU

Was this reply helpful? Yes No
Nithyan G 22 on at

Like (1)

Report

Performance Impact on Large Business Central Databases and limitations

Hi Yun Zhu,

Thank you for sharing the details.

From my understanding, based on the information you've provided, the database growth limits were not defined by Microsoft. Is that correct?

Also, can an on-premise Business Central environment handle similar requirements to BC Online (as discussed in BC Tech Days) with appropriate resourcing?

Looking forward to your insights.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,590 Most Valuable Professional on at

Like (2)

Report

Performance Impact on Large Business Central Databases and limitations

Hi

I hope this can help you

Performance of Business Central On-Premises Installations - Business Central | Microsoft Learn

Dynamics 365 Business Central: is my on-premises customer ready for SaaS? – Stefano Demiliani

Dynamics 365 Business Central on-premise performances to the max with Azure SQL Database Hyperscale – Stefano Demiliani

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,222 Super User 2025 Season 2 on at

Like (0)

Report

Performance Impact on Large Business Central Databases and limitations

Yes, Microsoft does not limit the upper limit of the database. But as you know, BC is an ERP system for small and medium-sized enterprises, and the database design is not as good as FO or SAP.

If the database capacity exceeds a certain size, querying, opening certain pages, and posting may affect the speed, especially when there are customizations.

So Microsoft also provides the following document,

Performance Overview

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-overview?wt.mc_id=DX-MVP-5004336

Hope this can give you some hints as well.

Thanks.

ZHU

Was this reply helpful? Yes No