- #MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION HOW TO#
- #MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION INSTALL#
- #MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION UPGRADE#
- #MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION WINDOWS#
So what exactly is the problem and why does this occur?Īt first glance you might think that this is a bug in SQL Server, but it isn't. This is clearly evident in the runnable tasks counts for the four schedulers in the second NUMA node, which are three to four times the size of those for the schedulers in the first NUMA node. This information shows a significant imbalance and performance is going to be affected as a result. You can also see this symptom visually in monitoring tools such as SQL Sentry Performance Advisor:įigure 4 – NUMA imbalance as shown in SQL Sentry Performance Advisor dm_os_schedulers WHERE = N'VISIBLE ONLINE' Īn example output of this query under load is shown in Figure 3 below.įigure 3 – Schedulers under load with Enterprise Server+CAL In SQL Server under the Enterprise Server+CAL licensing model, this results in a scheduler configuration that is similar to the following:įROM sys. The VM was configured to have 32 virtual CPUs with 16 virtual processors allocated in two vNUMA nodes.
#MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION WINDOWS#
To demonstrate this I created a VM on our Dell R720 test server which has two sockets and Intel Xeon E5-2670 processors installed, each with 8 cores and Hyperthreading enabled, providing a total of 32 logical processors available under Windows Server 2012 Datacenter Edition. As a result, performance problems can occur for the instance, due to NUMA node scheduler imbalances.
With the default configuration that SQL Server applies under the 20 logical processor limitation using Server+CAL, the first 20 schedulers are VISIBLE ONLINE and any remaining schedulers are VISIBLE OFFLINE. This is an informational message no user action is required. SQL Server detected 2 sockets with 16 cores per socket and 16 logical processors per socket, 32 total logical processors using 20 logical processors based on SQL Server licensing. This licensing also extends to VMs with a limit of 4 VMs being covered by the Enterprise Server+CAL license, but still with the same 20 logical processor limitation as documented in the SQL Server 2012 Virtualization Licensing Guide.Ī lot of people have been caught off guard by the 20 logical processor limitation, even though it is documented in the licensing guides.Īn entry is made in the ERRORLOG file when the instance starts up, specifying the number of logical processors and that the 20 processor limitation is being enforced:
#MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION UPGRADE#
Customers under Software Assurance can upgrade to SQL Server 2012 Enterprise Edition and still use Server+CAL licensing (also known as "grandfathering") but with a limitation to 20 logical processors, as documented in the SQL Server 2012 Licensing Guide. One of the challenges that Microsoft faced with this change was providing a migration path for customers that previously used Server+CAL based licensing for Enterprise Edition prior to SQL Server 2012. Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.Numerous licensing changes were introduced in SQL Server 2012 the most significant was the move from socket-based licensing to core-based licensing for Enterprise Edition.
#MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION HOW TO#
For more information, click the following article number to view the article in the Microsoft Knowledge Base:Ģ755533 How to obtain the latest service pack for SQL Server 2012 Status To resolve this problem, obtain the latest service pack for SQL Server 2012.
Service pack information for SQL Server 2012
#MICROSOFT SQL SERVER 2012 ENTERPRISE EDITION INSTALL#
ResolutionĪfter you apply the fix, you cannot install DQS in the Standard edition of SQL Server 2012. However, when you try to install DQS in the Standard edition of SQL Server 2012, the operation is completed successfully. When you try to install SQL Server Data Quality Services (DQS) in Microsoft SQL Server 2012, it should only be supported in the Enterprise edition and the Business Intelligence edition. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release. Microsoft distributes Microsoft SQL Server 2012 fixes as one downloadable file.