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
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...