Skip to main content

Notifications

Announcements

No record found.

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

Performance Issue executing tasks

(0) ShareShare
ReportReport
Posted on by 5

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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Performance Issue executing tasks

    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.

  • GAndrea Profile Picture
    GAndrea 5 on at
    RE: Performance Issue executing tasks

    Hi, I check that.

    Apparently I have 1 socket, 8 cores on the virtual machine. Virtual machine is a HyperV one.

    Screenshot-2023_2D00_03_2D00_20-160601.png

    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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Performance Issue executing tasks

    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

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-overview

    pastedimage1679270691186v1.png

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Performance Issue executing tasks

    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:

    learn.microsoft.com/.../sql-server-not-using-all-cores

  • GAndrea Profile Picture
    GAndrea 5 on at
    RE: Performance Issue executing tasks

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Performance Issue executing tasks

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans