Open Forum

Sever Configuration For NAV

By Elizabeth Earley posted Aug 20, 2019 06:23 AM

We have one physical server, it currently hosts two virtual machine, one is DC, another one is NAV server with SQL installed as well. We have around 30 Users, can NAV be hosted on a Virtual machine?   Our SQL log drive and SQL Data are both VHD sit on two separate RAID 10 configured drives.  Is this the best way to configure NAV?



Sep 17, 2019 03:53 PM

And you may consider moving this from "blogs" to "discussions" as this is more of a discussion.  Others may not look here in "blogs" for a question.  You may have more input in "discussions".

Sep 17, 2019 03:51 PM

One can "put everything on one server" but in my opinion that is suitable for smaller environments. As the environment grows, "separating roles onto separate servers" becomes compelling, provides added flexibility, etc. If a company is in growth mode, I prefer to start with "separating roles onto separate servers" right out of the gate. But one must have the physical resources to support it.

The VM's share the underlying physical resources of cpu, disk, memory, and network. So building a separate VM does not automatically make it go faster. In fact, the additional VM might make it go slower if the underlying physical resources are inadequate to support it.

Since there are many layers involved: physical hardware, virtualization layer, operating system, server applications, client considerations, etc. identifying the bottleneck can be tricky. In my experience, modern server CPUs tend not to be the bottleneck. Neither does the network unless you're not local to the servers and a wide area network is involved. The most common bottlenecks that I encounter are memory and disk. Adding physical memory to the server so more memory can be provisioned to the virtual machine is one option.

Disk is often the bottleneck. I hope in your initial question by "two separate RAID 10 configured drives" I hope you are not suggesting that you literally have only four disk drives: two disk drives configured RAID 10 + two disk drives configured RAID 10. Unless those drives are SSDs that deliver very high IOPS, you'll need more disk drives to increase performance. You may have enough space, but performance is driven by the number and type of drives in the array. For perspective, I have 40 users in NAV and I have a Direct Attached Storage Array containing 24 x 15,000 RPM SCSI disk drives configured RAID 10. That performs adequately for our environment and NAV is fairly snappy.

Aug 28, 2019 07:32 AM

Thank you for your advice. We probably can set up anther VM on the server, and make it host SQL only for NAV. It this what you think might improve the speed?

Aug 22, 2019 12:11 PM

Can the NAV service tier and related SQL Database run on virtualized servers? Yes. There are guidelines for CPU, memory, disk, and network requirements in the NAV documentation. If by "two seaparate RAID 10 configured drives" you literally have two disk drives configured RAID 10 that is very light as drive count in the array scales performance. You may want to consider separating the NAV Service Tier and SQL Server onto separate Windows servers if you have sufficient physical resources to support the virtual servers.  Have you tested NAV with this configuration to see if it runs adequately with multiple active users?