Hi everybody.
I am new here. I am Italian and we moved to Microsoft BC mid 21. I hope to find support here for this issue.
We have Microsoft Business Central 19 Release installed on-premises and a SQL 2022 Standard Database. ERP and DB are installed on virtual machines with different virtual cores. Physical machine is multicore with nvme.
I am experiencing performance issues with some tasks. The point is that while my client is running this task for 20/25 minutes, the resource usage on both virtual and physical machines is very low (14%cpu, ram is available). But the task requires a lot of time to be executed. SLQ is set on multicore. I tired running the same task on the server, with the same account and the problem is still there.
The task I am running is "cost allocation" and it's set on a month period. I also tried the task "GR Calculate End Year costs" both live and scheduled and it is using the same amount of resources.
Why does it takes so long, if the system has more resources that can be used? Is there something that it is possible to do?
Thank you for your help.
Kind regards.
Andrea