Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks | Architecture Insights
My 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.
in both cases SQL are in the same machine? same to AD?
Yes they are on the same machine in both cases.
NAV on virtual machines is quite common nowadays.
My current client has two productional ServiceTiers as virtual machines (Azure) and no problems.
I'm not an admin, but I think it's either your test-case which causes problems or the configuration of the host-server.
You could create a pre-configured NAV-machine in Azure and run your test. That would exclude the possibility that NAV is not compatible with virtual machines as a host system.
Business Applications communities