Q. “When am I supposed to report SQL core licenses?”
A. When you sign a new SPLA or you deploy SQL 2012 you will be forced to license by cores
Q. “If we leverage SQL Server Enterprise, are we able to launch multiple VM instances of database across the enterprise?”
A. SQL 2012 Enterprise allows unlimited virtual instances. In order to this with the 2008 version you would of had to license Datacenter edition. (way expensive btw). SQL 2012 does allow license mobility within server farms as well. Check out the SPUR for details.
Q. “Does SQL 2012 Enterprise edition allow for downgrade rights? In other words, can I have 2008 SQL servers and 2012 SQL servers running virtualized on the same host?”
A. Yes, as long as you are reporting SQL 2012 cores, you can run 2008 and prior. Keep in mind, it has to match version. For example, if you license Standard, you cannot run Enterprise. If you license Enterprise, you can run Enterprise or Standard.
Q. Can I just license the virtual, not the physical machine?
Yes. SQL does allow you to license just the virtual machines. You would report the number of cores you assign to the server. (minimum of 4 cores).
Q. Can I license SQL Enterprise by user?
A. No. Unfortunately SQL Enterprise can only be licensed by core. SQL Standard and SQL Business Intelligence SKU can be licensed by user.
May 1, 2014 at 5:47 pm
With SQL2012 core 2 pack license, can I license a physical processor or two in a server and have unlimited virtual instances on the windows hyperV above? If so, assuming all virtual SQL 2012 servers are standard edition, how many cores do I need to license on the physical servers. Am I to assume if I have dual socket 8 core processor, so 16 cores total, I would then pay for 16 cores. So 8 SPLA licenses with 2cores per license?
May 13, 2014 at 8:18 am
SQL 2012 is licensed by the core; not by processor. You can just license just the physical layer as long as there are no VM’s running SQL (for SQL Standard). In your example, you would license (8) 2 core packs or 16 cores.
Windows, is licensed by physical processor. If you license every physical proc on the host, you can run unlimited VMs of Windows.
Hope this helps