With SQL Server , Microsoft introduced a new licensing model; licensing per core replaced the licensing per processor. We need to adjust. Microsoft Pledges to Use ARM Server Chips, Threatening Intel's .. and focus on Intel E7 (and SQL Server enterprise if you are an MS shop). Automatically set processor affinity mask for all processors. Allows SQL Server to set the processor affinity. Automatically set I/O affinity mask for. Since Microsoft revamped the licensing model for SQL Server , it is especially important to do some thoughtful analysis before you decide. I am admin of a SQL R2 member machine on Server R2 SP1 2. My processor config is 2 sockets of 6-core Intel Xeon X at GHz, 12 threads per to adopteesofcolor.org(v=sql).aspx. Microsoft charges the same SQL Server core license prices regardless of the performance of each processor core. Given this, you need to try to. The upcoming availability of SQL server on Linux is all the proof we need that Of course, Microsoft isn't the only buyer of these chips and they. Intel Xeon Scalable Processors and SQL Server In SQL Server , Microsoft introduced support for SSE and AVX instructions. A thread or logical processor is one logical computing engine from the perspective of SQL Server, the operating system, an application, or a. Running Microsoft SQL Server without enough CPU resources will The NUMA nodes have busses connecting them, so processors can.