SQL Server and CPU Hyper-Threading in Virtual Environments

I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be factored into CPU overcommitment rations as if they are full processor cores. Every...

SQL Server and VMware Resource Pools

Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over others, especially in a highly concurrent VM farm, I recommend leveraging three...

SQL Server on Linux? Start on Azure

I’ve talked for months now about the ability to run SQL Server on the Linux platform. For those of you interested in exploring the benefits of this platform, you’re in luck! Microsoft has pre-built images ready to go on the Azure cloud, running SQL Server...