326
Our staff have been reporting that our Business Central production instance seems to slow down around the same time (4:30PM) each day.
Users report getting the "Working On It..." window and the system taking much longer than usual to complete ordinary tasks.
Where should I start to diagnose this slow down?
Hello,
You can do a lot of things yourself. Please have a look here:
docs.microsoft.com/.../performance-online
Thanks.
The SQL statistics should not apply if you are on the Saas version. Did you get your problem solved?
I checked the job queue entries and didn't find anything there. The main time when our users post documents is in the morning, so I don't believe that is causing the issue. We don't post that many documents in a day, maybe 20-30 sales invoices and a similar amount of purchase invoices.
Regarding SQL Statistics, we are using the SaaS version of Business Central. Does the second part of your reply apply to the cloud version or on-prem only?
I agree with Franz. Also, check if this can be the period where all users start to execute posting operations (e.g., accumulating documents during the day and posting them).
Another reason might be in SQL Statistics. If you perform rebuild indexes every night, your both indexes and statistics is updated. During the day the performance might go down, as the statistics is updated by default when 20% data or more is added or modified in the table (which is e.g. 200,000 records per 1 million record table). So with statistics not updated it might cause slow-down after midday. If I'm not mistaken, starting from SQL 2008 R2 SP1 there is a 2371 flag which you can fire up in SQL to enable update statistics more often.
#1
YUN ZHU
628
Super User 2025 Season 1
#2
Mansi Soni
495
#3
Sagar Dangar, MCP
395
Share
Report
All responses (
Answers (
