The second option is to use SQL Server Management Studio Connect to the server using the object explorer Right click on the instance in the object explorer and select the CPU tab Expand the "ALL" option However many NUMA nodes are shown is the number of NUMA nodes that you have as shown below Logical CPUs can be relegated to the SQL Server instance to access those only by the SQL Server Processor property Logical CPUs will be listed in the server property as are configured or associated with the machine or virtual machine A rundown of CPUs will be bifurcated with the numa node (Processor Socket) SQL uses all CPUs available from the operating system It creates schedulers on all the CPUs to make best use of the resources for any given workload When multitasking the operating system or other apps on the SQL server can switch process threads from one
Configuring Sql Server Processor And I O Affinity Emarjm
