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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Business Central Saas Performance with Overusage of Capacity

(9) ShareShare
ReportReport
Posted on by 96
Hi,
 
Can anybody tell me how overusage of capacity impacts business central performance(specially impact on customization and job queues)?
 
Currently one of my  client is at 482 GB usage and they have capacity of 452 GB, so when i am running job queue to do some customization it is taking lot of time.
The Sandbox of the client has about 5 GBs of Data if run the same job queue in sandbox it is processing about 150 lines in a min but in production it is processing only 10 lines in a min.
I have the same question (0)
  • Suggested answer
    Tech-Lucky Profile Picture
    1,286 Moderator on at

    Hi,

    Yes, this is correct. When the Business Central capacity is fully consumed, the client’s environment does not stop, but it will become slower, and creating new environments will no longer be allowed.

    To address this, you can perform some troubleshooting steps to improve performance:

    1. Performance Profiler – Use this tool to identify if the slowness is caused by a specific extension, object, or unnecessary code.

    2. Check database table sizes – Review and monitor large tables that may be affecting performance.

    3. Retention Policies – Apply retention policies for heavy Change Log entries or other large tables.

    4. Delete unnecessary or expired documents – If compliant with regulations, remove obsolete or expired documents.

    5. Purchase additional storage – If required, expanding storage capacity can help.

    6. Backup and offload heavy data – If the issue persists due to Change Log entries or large volumes of ledger data, one alternative is to export a backup file from the Admin Center and restore it on a local SQL Server. This allows you to retain historical data for audit purposes while cleaning up Change Log entries and heavy tables in your main production environment.

     
  • Suggested answer
    Dhiren Nagar Profile Picture
    2,898 Super User 2026 Season 1 on at
    Hi,
     
    Over usage of Business Central database capacity does not stops you from using the BC, however it may impact the performance based on number of records in the table or tables where your AL Code or Job queue is looking up for the data.
     
    Hence even through the actual performance has not been decreased but the number of records and database size does effect the processing of code specially when it is looking up data from database tables. Microsoft has mentioned you can use environment as normal scenario.
     
     
    You need to check the number of database records in the tables in Sandbox and in Production. Also you can optimize your code to have as much less Database calls as possible. In AL Code usually database calls are the ones which consumes most of the time. You can use Performance Profile as well to evaluate the performance in both the environment.
     
    ✅ Mark this as the verified answer if helpful.
     
    Regards,
    Dhiren.
     
  • Suggested answer
    Sumit Singh Profile Picture
    11,761 Super User 2026 Season 1 on at
    When your database exceeds the allocated capacity, Business Central performance degrades significantly because:
    • SQL operations slow down due to large data size and index fragmentation.
    • Job Queues and custom processes take longer because queries and writes hit large tables.
    • Background tasks (posting, batch jobs) compete for resources, increasing latency.
    Action: Reduce data size (archive, purge logs, compress tables) or purchase additional capacity to restore performance.
     
    Official links:- 
     
     
    Mark the Boolean true “Does this answer your Question” if this is Helpful.
     
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,171 Super User 2026 Season 1 on at

    Yes , going over the storage limit will slow down performance in production (job queues, posting, customizations) because BC starts throttling when capacity is exceeded. That’s why your sandbox feels much faster.

     
    • Review and delete/archive unnecessary data.
    • Set up a retention policy (for things like change log, job queue log, and integration records) so old data is cleared automatically.
    • If cleanup isn’t enough, consider buying extra storage.
     
     
     
     

    ✅ Mark this as the verified answer if helpful.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,304 Super User 2026 Season 1 on at
    It depends on your process.
    Your process does slow down the more data you have.
    Sandbox run in a different performance tier than production, so you cannot really compare both properly.
  • Suggested answer
    YUN ZHU Profile Picture
    99,859 Super User 2026 Season 1 on at
    The size of the database does affect search performance.
    However, it is recommended that you use the In-client performance profiler to check which process is slow. If it is custom code, please update your solution.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    9,114 Super User 2026 Season 1 on at

    Hi,

    When a BC SaaS tenant exceeds its allocated capacity, performance degradation is a known side effect, especially for job queues and custom extensions that rely on heavy data processing.

    At 482 GB usage against a 452 GB limit, your client’s environment is technically over capacity. While BC won’t block transactions outright, it will throttle performance in subtle ways — slower query execution, delayed job queue cycles, and reduced responsiveness in custom logic. The sandbox comparison you shared is telling: 150 lines per minute vs. 10 in production is a clear signal of resource strain.

    Here’s what you can do to mitigate the impact:

    • Use the Performance Profiler to identify bottlenecks in your customizations. It can help isolate slow-running objects or inefficient loops.
    • Review table sizes in the admin center. Tables like Change Log, Ledger Entries, and Document Archives often grow unchecked.
    • Apply retention policies to purge or archive old data. For example, you can offload historical Change Log entries to a local SQL backup for audit purposes.
    • Delete expired or unused documents if compliance allows. Even small reductions in table size can improve performance.
    • Consider purchasing additional storage capacity through your CSP partner. Microsoft offers 1 GB and 100 GB add-ons, plus overage options if you’ve already maxed out your base entitlement.


    Helpful references:
    Managing Capacity – BC
    Top 10 Performance Issues with BC SaaS
    How to Manage Storage Capacity in D365 BC – Osmosys
    Application Insights for BC Performance

    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

  • Suggested answer
    Khushbu Rajvi. Profile Picture
    22,287 Super User 2026 Season 1 on at
  • Suggested answer
    Satish Srivastava Profile Picture
    242 on at

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 Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,951 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,141 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 752 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans