SQL Server Virtualization: Mo Cores, Mo Problems

Non-Uniform Memory Access (NUMA) is a type of computer design popping up more and more these days. In simple terms, it means that when a processor core accesses different areas of the server’s memory, not all memory will be accessed the same way. Some memory may be faster or slower depending on where it’s wired […]

SQL Server Virtualization: Get Your Hands Off That MAXDOP

Virtualization makes a sysadmin's life easier by abstracting away the hardware. The hypervisor (like VMware ESX, Microsoft Hyper-V, or Citrix Xen) sits as a layer between the physical server and the virtual server, offering a set of general hardware services like network cards, video cards, SCSI adapters, and so on. In Device Manager, these drivers […]