web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Performance issue | MS...
Small and medium business | Business Central, N...
Suggested Answer

Performance issue | MS Dynamics 365 Business Central (Version 14)

(1) ShareShare
ReportReport
Posted on by subrata.bauri 1,156

Dear All,

In the Cloud, we have two servers one for SQL Database and another for NAV Application. The SQL Server Machine is running with 8GB RAM (25% Free) & the Application Server Machine is running on 16 GB (50% Free). The database size is less than 2.5 GB. Concurrent users are a maximum of 5. Both the Servers have an efficient processor.

Still, a very simple report is consuming too much time to display preview.
What could be the reasons in this case?

Please let me know if you need any further information.

Thank you,
Subrata Bauri

  • Community Member Profile Picture
    Community Member on at

    Is it using an efficient index/key? Many records in the table? Define simple.

  • subrata.bauri Profile Picture
    subrata.bauri 1,156 on at

    Report is based on two table (Table 1 & Table 2)..Without any code.

    Table 1 has two fields

    1. No.  (PK)

    2. Information

    Table 2 has three fields

    1. Document No. (PK)

    2. Line No. (PK)

    3. Item No.

    First DataItem is Table 1 & Second DataItem is Table 2 & indented.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    To check why the report is so slow, I suggest to verify if you have flowfields or if you have code inside your dataitem that loops.

    Off topic: Regarding your configuration, SQL Server machine should have at least the same RAM size as the application server, quite strange that it's less (only 8 GB). More ram you have for SQL, more database is cached (so better performances).

  • subrata.bauri Profile Picture
    subrata.bauri 1,156 on at

    There is no flowfiled & no code. The 2 table have only three records.

    I agree that SQL Server must have more RAM. But 8 GB is quite sufficient in this Test environment (only 5 concurrent users are working with bit size of data and even single user mode is also facing the same performance issue)

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    There's no reason for performance problems on a 3 records tables.

    I think the problem here could be the network or the report viewer component or something related to the environment. You could also check the event viewer if something here is present.

  • Community Member Profile Picture
    Community Member on at

    Nothing funny like an Integer loop running unbounded?

  • subrata.bauri Profile Picture
    subrata.bauri 1,156 on at

    Communication between these two server is fine. What shoulf I look for the below component...?

    1. Report Viewer Component

    2. Environment

    3. Event Viewer

  • subrata.bauri Profile Picture
    subrata.bauri 1,156 on at

    There is no infinite loop.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    We cannot help without seeing the tables structure and the report definition then...

  • subrata.bauri Profile Picture
    subrata.bauri 1,156 on at

    I will share in text format.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans