SQL Server 2012 will be available this April. What does this mean for SQL server users? Current holders of Microsoft Software Assurance on SQL Server have until the end of their current term to trade-in Per Processor licenses for Per Core licenses as the new license model is introduced for SQL Server 2012. The following scenario affects only SQL Server deployments in the Per Processor license model covered by Software Assurance.
So……If you have a SQL server deployment using the Per Processor license modeled AND you are covered by Software Assurance, you can get more value from your core licenses by doing a self-inventory.
Step 1: By using the Microsoft Assessment & Planning (“MAP”) Toolkit or another suitable inventory tool that timestamps the report, the company can identify the number of cores per server for each qualified server. If the customer does not perform this self-inventory, they will receive the minimum:
o 4 Core licenses for each Enterprise Edition or Standard Edition Processor licenses in their inventory
o 8 Core licenses for each Datacenter Edition Processor license in their inventory
Step 2: Microsoft will then provide the customers with the appropriate number of core licenses that allows them to continue their current deployment with no additional licensing required. Microsoft has imposed a limit of 20 cores per server.
• Example 1: A server running SQL Server Enterprise Edition is configured as 2 processors, each with 2 cores. The required licensing under version 2008 R2 is two (2) Processor licenses. The customer would receive four (4) Core licenses (i.e., 2 processors X 2 core).
• Example 2: A server running SQL Server Standard Edition is configured as 2 processors, each with 1 core. The required licensing under version 2008 R2 is two (2) Processor licenses. The customer would receive four (4) Core licenses. Though the number of total cores in the server is two (2), the customer would receive four (4) Core licenses because this is the minimum.
• Example 3: A server running SQL Server Datacenter Edition is configured as 4 processors, each with 4 cores. The required licensing under version 2008 R2 is four (4) Processor licenses. The customer would receive sixteen (16) Core licenses (i.e., 4 processors X 4 core).
• If the customer has SQL Server Processor licenses in an existing Enterprise Agreement, they may continue to purchase Processor licenses throughout the end of the term. They will then perform the self-inventory as described above.
So, in this case, Software Assurance arguably is tangibly beneficial because the customer can actually receive more Core licenses than their Processor licenses are worth. That is, Core licenses will cost one-quarter of the Processor license price. So, for example, if the a server has two (2) processor licenses each with eight (8) cores running SQL Server Enterprise Edition, then the customer receives sixteen (16) Core licenses, which would equate to four (4) Processor licenses.
I know it can be confusing, but the end result is a scenario where you get more for you money.