SQL Server 2012 does not fully use the CPU's logical core number problem

Recently encountered in the work, SQL Server 2012 can not put the core of the CPU all the problem, believe that many people have encountered this problem, so today this section first to say how this problem arises.

First introduce the environment of the server

Windows R2 Enterprise Edition (X64) + Microsoft SQL Server (SP1) Enterprise Edition (64-bit)

CPU 2-way 18-core is 72 core after Hyper-threading is turned on

Then look at the properties of the SQL instance

SQL Server has actually recognized the total number of cores 72

So does SQL Server have all the means to use it, and through the system view you can see

There are only 40 cores that SQL Sever really use.

So we know that the concept of process group is the technology introduced in Windows Server (x64), SQL Server R2 and later versions, all using the technology of Process group, why SQL Server The Enterprise Edition (64-bit) actually still has this question,

Is it a little unreasonable?

is not the version of SQL is wrong, then I run the SELECT @ @version to view the version of the command, to find out that the version is

Microsoft SQL Server (SP1)-11.0.3128.0 (X64) Dec 20:23:12 Copyright (c) Microsoft Corporation En Terprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601:service Pack 1) is a 64-bit Enterprise Edition! Why not? After finding out on the internet, there are two types of SQL Server 2012 Enterprise Edition, one of which is seen above, he can only recognize a single group of 64 cores, because of the reason of processor grouping, it only used one of the set of 40 core, and another set of 32 core, no way to use. The easiest way to do this is to upgrade the existing SQL version to SQL Server ENTERPRISE CORE Edition open the SQL Servers installation Center

Maintenance-Version Upgrade

Enter the core version of the serial number, and then proceed to the next step to keep it up.

Next, we'll see if SQL Server is really true at this point, with all 72 cores.

At this point, we then use the SELECT @ @version to look at the SQL version information

Microsoft SQL Server (SP1)-11.0.3128.0 (X64) Dec 20:23:12 Copyright (c) Microsoft Corporation En Terprise edition:core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601:service Pack 1) We see CORE-BA Sed Licensing's logo!!

SQL Server 2012 does not fully work with the number of logical cores on the CPU