With Dynamic Memory, Hyper-V can provide a virtual machine with more or less memory dynamically in response to changes in the amount of memory required by the workloads or applications running in the virtual machine. Dynamic Memory helps you use memory resources more efficiently,
However, some heavy load database application like SQL server may not work well with dynamic memory and it may makes it possible to a Hyper-V server’s physical memory. In this case, you may assign statics memory to VM.
Advantages and Disadvantages of Hyper-V Dynamic Memory
Hyper-V Dynamic Memory is a useful feature which offers a lot of advantages, such as:
Reduced memory consumption, as the VM uses only the amount of memory that it actually needs within the limits set by an administrator
Efficient memory distribution, as you can dynamically assign more or less memory to the running VM
Higher consolidation numbers due to the more efficient use of memory resources
Enhanced reliability for restart operations with the help of Hyper-V Smart Paging
Cost-efficiency as VM resources are not wasted
However, Hyper-V Dynamic Memory also has a number of disadvantages, which can negatively affect VM memory performance. They include the following:
Risk of overprovisioning computer physical memory in case you don’t keep track of memory allocation within your virtual environment
Some memory settings cannot be changed when the VM is running. Thus, you cannot decrease or increase the maximum and the minimum memory amount, as well as modify the VM startup memory amount, when the VM is still running or paused.
When Hyper-V Dynamic Memory is enabled, issues with database applications may occur. It is recommended that you use applications that are compatible with Hyper-V Dynamic Memory to avoid any performance issues.