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

Notifications

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)

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

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

I have the same question (0)
  • 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,144 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,166 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,144 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,166 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,144 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,144 on at

    There is no infinite loop.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 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,144 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans