Number of CPU Limits for SQL Server 2014
Below are the number of CPUs supported by the different editions of SQL Server 2014.
Enterprise Edition: Core-based Licensing1 – Operating system maximum
Developer Edition – Operating system maximum
Evaluation Edition – Operating system maximum
Business Intelligence Edition – Limited to lesser of 4 Sockets or 16 cores
Standard Edition – Limited to lesser of 4 Sockets or 16 cores
Web Edition – Limited to lesser of 4 Sockets or 16 cores
Express Edition – Limited to lesser of 1 Socket or 4 cores
Express with Tools – Limited to lesser of 1 Socket or 4 cores
Express with Advanced Services – Limited to lesser of 1 Socket or 4 cores
Enterprise Edition with Server + Client Access License (CAL) based authorizing (not accessible for new understandings) is constrained to a greatest of 20 cores every SQL Server case. There are no restrictions under the Core-based Server Licensing model.
In a virtualized domain, the process limit utmost is taking into account the quantity of intelligent processors, not centers, on the grounds that the processor structural engineering is not unmistakable to the visitor applications. Case in point, a server with four attachments populated with quad-center processors and the capacity to empower two hyperthreads every center contains 32 legitimate processors with hyperthreading empowered yet just 16 intelligent processors with hyperthreading incapacitated. These sensible processors can be mapped to virtual machines on the server with the virtual machines’ register stack on that legitimate processor mapped into a string of execution on the physical processor in the host server.
You may need to incapacitate hyperthreading when the execution every virtual processor is essential. One can empower or handicap hyperthreading utilizing a BIOS setting for the processor amid the BIOS setup, however it is regularly a server perused operation that will affect all workloads running on the server. This may propose dividing workloads that will run in virtualized situations from those that would advantage from the hyperthreading execution support in a physical working framework environment.
Hope this was helpful.
This is applicable for below versions of SQL Server
SQL Server 2014
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings