Home > Workload Solutions > SQL Server > White Papers > Modernize Your Microsoft SQL Server Platform and Accelerate Deployments > CPU affinity
CPU affinity is the capability to define which processor cores the SQL Server engine uses for multitasking. By assigning processor cores, SQL Server only uses those processors for multitasking database operations. This can improve performance by reducing processor reloads and thread migration across processors.
The virtual machine supporting SQL Server has 6 allocated vCPUs. For this reason, we implemented the following configuration changes as part of this best practice: