Erik Darling takes us through some of the most common issues when setting up VMs to run SQL Server:
Everyone’s on VMs these days. That’s cool. Nothing against computers.
But here’s how people screw up SQL Server on VMs bigtime:
– Fewer than 4 cores (this is a licensing minimum)
– Multiple single-core sockets
– Not fully reserving memory
– Oversubscribing hosts
All four of those are bad and Erik explains why.