#SERVER MEMORY OPTIMAL LAYOUT LICENSE#

Right-sizing is picking the appropriate level of resources for each guest VM. Due to the nature of the hypervisor and virtualization uses there are key differences with regard to resource allocation compared with a physical server. By this we do not mean capacity planning – that is a different subject. All of this is useful when planning to virtualize SQL Server on VMware.ĭavid Klee has some well written posts that explain the concept of right-sizing your VM. OLTP vs OLAP databases can differ in approach. Our Service Level Agreements (SLA) will dictate which hardware we run on. Understanding your SQL Server workloads will help determine the level of each resource required.

#SERVER MEMORY OPTIMAL LAYOUT LICENSE#

Right-Sizing Your VM Image / License – Do not overflow your servers! The document contains many citations you can research to go more in depth should you choose. We won’t talk about extra VMware features such as vMotion. The whole paper is worth a read however, I will explore only a few parts. I will point out some key points that are practical to implement. Read on to look into the details…įirst – you should read the white paper then come back…I’ll wait…Īrchitecting Microsoft SQL Server on VMware vSphere SQL Server and VMware go together like peanut butter and jelly. Twenty years ago VMware launched and forever changed the compute world. Published in August 2018, it spells out the best practices for running SQL Server on vSphere. A couple of months ago, VMware released a new white paper called “Architecting Microsoft SQL Server on VMware vSphere”.

Server memory optimal layout