Virtual Disk Provisioning and Memory best practices for VMware Virtual SQL Servers

JB Blanco
JB Blanco used Ask the Experts™
on
is it really Best practices and better, to use Thick Provisioned Virtual Disks on VM's that will be Microsoft SQL Servers?

 Also is 6GB of memory too low for a virtual SQL Server?

I am asking these questions because in our current environment i am noticing alot of VM's that are SQL Servers with Very little ram and also noticiing the Virtual Disks are all Thin.  

Our LUNs on the SAN side are all thick just an FYI.

From my understanding, i was told always use THICK for SQL, and i have never seen a sql server with only 6gb of ram.  I know there are ways to have SQL use less ram from within SQL itself.  

Just want a confirmation on the best practices, and real life experience.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017
Commented:
this is the Bible:-

ARCHITECTING MICROSOFT SQL SERVER ON VMWARE VSPHERE® Best Practices Guide

Eager Zeroed VMware virtual Thick Disks are theoretically faster than thick and thin!

But you would have to benchmark to notice the difference.

As for memory in an SQL server, depends on the database, concurrent users etc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial