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

System Locking Up at the Same Time Each Day

(0) Share

Report

Posted on by dkkipfer

336

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?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

keoma 32,729 on at

Like (0)

Report

could be that there are jobs running at that time or long running reports. check the job queue entries.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
dkkipfer 336 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

The SQL statistics should not apply if you are on the Saas version. Did you get your problem solved?

Was this reply helpful? Yes No
dkkipfer 336 on at

Like (0)

Report

The problem has not been solved yet.

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

You can do a lot of things yourself. Please have a look here:

docs.microsoft.com/.../performance-online

Thanks.

Was this reply helpful? Yes No