Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Performance issue | MS Dynamics 365 Business Central (Version 14)
navuser1
Member Posts: 1,329
Dear All,
In the Cloud, we have two servers one for SQL Database and another for NAV Application (BC Application Server). 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,
Navuser1
In the Cloud, we have two servers one for SQL Database and another for NAV Application (BC Application Server). 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,
Navuser1
Now or Never
0
Answers
Are there any index optimizations to be done on the SQL database?
That said, i'm not super impressed with the performance, Classic were much faster, but we cant live in 2009 for the rest of our lives. I think BC16 is faster than the previous versions.
1. Disk Format
2. Max Degree of Parallelism
https://docs.microsoft.com/da-dk/dynamics-nav/installation-considerations-for-microsoft-sql-server
But I don't think that a simple test environment would require such type configuration. Obviously, I will follow the ms recommendation for the Production level deployment as you mentioned.
I have a Standard laptop (with 8 GB RAM & i5 Processor) & it provides me better performance.
I tested the max degree, an on a simple customerlist lookup, i went from 7 to 4 seconds, just because i set it to 1.
Coinsisent, maybe, but try it, no restart needed, and you can change it back.
Your laptop, does it run on SSD?
Either way, i have seen excactly the same, a laptop outperforms a server.
Sorry i cant tell whats wrong, we see the same issues from time to time...