Understand how to optimize MES performance in a virtual environment

VMware vSphere and Microsoft Hyper-V are commonly used to deploy MES in virtualized environments. Other virtualization platforms, including cloud-based solutions like Amazon Web Services (AWS), can also be used to host MES.

To optimize MES SQL Server performance in a VMware environment, consider the following recommendations:

• Ensure the total vCPUs assigned to all the VMs do not exceed the host's physical cores. Each core should have at most one vCPU.

• Avoid using hyper-threading. Hyper-threading can result in multiple logical CPUs on the same core and this may cause resource contention.

For more information on the above recommendations, refer to the Architecting MS SQL Server on VMware Vsphere Best Practices Guide (https://www.vmware.com) and Microsoft's guidance on computing SQL Server capacity limits (https://learn.microsoft.com/en-us/sql/sql-server/compute-capacity-limits-by-edition-of-sql-server).

For more information on how to use AWS for virtualization, refer to Use AWS for virtualization in the System Platform documentation.