Share
ReportMy Company and I are working on the implementation of a water billing system with Microsoft Dynamics NAV 2013 R2. The main processes in this system are:
• Invoice generation (which is using standard NAV function to generate invoices in group)
• Posting invoices (standard NAV posting).
In the architectural point of view the system is based on a virtual machine on Windows Server 2012 R2 with Microsoft SQL Server 2014 Enterprise Edition.
We made the following configurations in the virtual machine:
1. RAM was configured from dynamic RAM to static 128 GB RAM.
2. All 3 VHDX of the Virtual Machine were converted from dynamic to fixed size.
3. The VCPU was converted from 6 VCPU to 24 VCPU.
We have also made configurations in SQL Server for increasing the performance (indexing, compressing, etc).
After testing this environment in terms of performance, the results we received were not performant. NAV took too long to generate the invoices.
These results are compared to another server we have in disposal. This other server is physical.
The difference in terms of performance between these two servers is quite significant, 3 or more times better in the physical server.
We are trying to figure out if there are any restrictions from the Dynamics NAV 2013 R2 side regarding the virtual machine environment. And is there any solution/workaround that we can use in order to have a similar performance as the physical server?
In terms of hardware specifications, SQL Configurations, NAV Administration everything is the same between the virtual and physical server.
The Virtual machine was chosen as an easier solution regarding the maintenance of the servers in the future (CPU, RAM, etc.).
I would really appreciate your opinion.
*This post is locked for comments
All responses (
Answers (
5,767
