As computing power, memory and disk space are readily available on virtualization hosts, the Disk I/O is often over-looked. As a matter of fact, it’s the number one factor affecting performance of virtualized Microsoft SQL Server.

Whether using Microsoft HyperV, VMWare, Citrix XenServer or any other virtualization platform, SQL Server performance has been an issue for high-volume Microsoft Dynamics GP Environment with I/O and resource intensive workloads. Here are some of the causes of performance bottlenecks and suggested improvements that could be undertaken to improve SQL Server & Dynamics GP Performance in such cases.

A case study on performance issues in Microsoft Dynamics GP when IT department relocates SQL Server from a Physical Server to Virtual Host to accommodate increase in disk space and memory requirements.

Performance problems on Web Client for Microsoft Dynamics GP 2015 when using dictionaries located on network/shared drives.