Solved

SQL 2008 licensing in VM Ware

Posted on 2010-08-19
6
526 Views
Last Modified: 2012-06-27
Hello:
I would like to know if the following is correct regarding licensing of SQL 2008 in VM:
(VMWare)
If we have a physical SQL box licensed for 2 x processors, quadcore and would like to move to VM. Microsoft says that in VM, each core is considered as a processor and should be licensed for it, in above case it will be 8 cores, therefore we should have license for 8 cores to move it to a VM?

My understanding was that if we build a VM with a single processor, you license for that processor, not the number of cores.

We are looking at upgrading SQL 2005 to SQL 2008 and therefore interested in understanding what MS advise specific to SQL 2008 licensing in VMWare.

Please help.



0
Comment
Question by:goprasad
  • 4
6 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33480757
Number of "processors" = number of physical processors.
So if you assign 4 cores to the VM from a 2 x quad machine, you can assume they are all from 1 processor and get a single per(1x)-processor license.
0
 
LVL 28

Expert Comment

by:bgoering
ID: 33481595
Take a look at http://www.dabcc.com/article.aspx?id=1546. This article does an excellent job of explaining your options.

Good Luck
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 500 total points
ID: 33481624
http://download.microsoft.com/download/3/d/4/3d42bdc2-6725-4b29-b75a-a5b04179958b/Licensing_Microsoft_Server_Products_in_Virtual_Environments.docx

Virtual Processors Have the Same Number of Cores and Threads as Physical Processors—Each Fraction of a Virtual Processor Counts as a Full Virtual Processor

If the physical processors in the server have two cores, each virtual processor also has two cores from a licensing perspective, even if the cores are allocated from separate physical processors.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33481636
Figure 7 shows a SQL Server setup with 2 cores, counting as 1 "CPU"
Hence my first comment, 4 cores = 1 CPU in a dual socket quad core setup.
0
 

Author Comment

by:goprasad
ID: 33490106
We won't be going for SQL 2008 R2  
But do you know of any Microsoft doco or URl which explains about SQL 2008 server licensing in VMWare
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33490129
The document linked above is published October 2008, which relates to the entire 2008 suite of products, including SQL Server 2008.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question