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
Then you should contact your partner and have them investigate this together with you. If you have customizations in your system that they have made those customizations may cause what you experience here.
Hi, I check that.
Apparently I have 1 socket, 8 cores on the virtual machine. Virtual machine is a HyperV one.
Cores are all online in SQL.
select scheduler_id, cpu_id, status, is_online
from sys.dm_os_schedulers
scheduler_id cpu_id status is_online
0 0 VISIBLE ONLINE 1
1 1 VISIBLE ONLINE 1
2 2 VISIBLE ONLINE 1
3 3 VISIBLE ONLINE 1
4 4 VISIBLE ONLINE 1
5 5 VISIBLE ONLINE 1
6 6 VISIBLE ONLINE 1
7 7 VISIBLE ONLINE 1
1048578 0 HIDDEN ONLINE 1
1048576 0 VISIBLE ONLINE (DAC) 1
1048579 1 HIDDEN ONLINE 1
1048580 2 HIDDEN ONLINE 1
1048581 3 HIDDEN ONLINE 1
1048582 4 HIDDEN ONLINE 1
1048583 5 HIDDEN ONLINE 1
1048584 6 HIDDEN ONLINE 1
1048585 7 HIDDEN ONLINE 1
1048586 0 HIDDEN ONLINE 1
1048587 1 HIDDEN ONLINE 1
1048588 2 HIDDEN ONLINE 1
1048589 3 HIDDEN ONLINE 1
1048590 4 HIDDEN ONLINE 1
1048591 5 HIDDEN ONLINE 1
1048592 6 HIDDEN ONLINE 1
1048593 7 HIDDEN ONLINE 1
1048594 0 HIDDEN ONLINE 1
1048595 1 HIDDEN ONLINE 1
1048596 2 HIDDEN ONLINE 1
1048597 3 HIDDEN ONLINE 1
1048598 4 HIDDEN ONLINE 1
1048599 5 HIDDEN ONLINE 1
1048600 6 HIDDEN ONLINE 1
1048601 7 HIDDEN ONLINE 1
1048602 0 HIDDEN ONLINE 1
The picture is taken form task manager and it shows usage during a 20 min query run by a user. Usage is very low.
Don't know what to do.
thanks
Hi, is this a standard environment? This may be a problem caused by customization. I hope the following information can give you some hints.
Performance Overview
Thanks.
ZHU
Then you should look into the config of the SQL server to figure out how many cores SQL is using and hove many it has avalible.
Mayb this can be of help:
Hi, thanks for reply.
Server has virtual machines on nvme drives, that have quite high r/w speed. compared to traditional scsi drives.
To me it's like the task is using only one core, and not multicore.
Have you checked your system for storage bottle necks?
Heavy BC operations can put a lot of load on your storage solution, so you should check for disk queues during the processing.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156