Home > Microsoft, Virtualization > Hyper-V Dynamic Memory Help SQL Server Workload

Hyper-V Dynamic Memory Help SQL Server Workload

One of the most important system resources for SQL Server is memory.

Lack of memory resources for the database engine results in increased I/O that is orders of magnitude slower than accessing memory.

One of the key benefits of leveraging dynamic memory is the flexibility to respond to the needs of a particular workload that would benefit from additional memory resources and make the most use out of all physical memory resources on a system.

VERY IMPORTANT : The benefit of additional memory depends on your workload.

The main highlights of using DM are:

– Without Hyper-V Dynamic Memory the virtual machines would have to be sized with a specific amount of static memory to ensure that all virtual machines could run on a single node in the case of a failover.

– The additional memory provides significant reduction in the number of I/O operations needed to support the same workload throughput.

– It should be noted that the benefit depends on your workload.

To read the complete review: :Running SQL Server with Hyper-V Dynamic Memory – Best Practices and Considerations

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: