Solved

SQL licensing options

Posted on 2011-02-14
11
482 Views
Last Modified: 2012-05-11
Hi,

I'm looking into making an SQL lic purchase.  
We already own a 2 proc sql lic for sql 2008 Std R2
We are thinking of buying an enterprise Lic for sql 2008 R2

I understand the products are downgradable  to 2008 standard (R1), and, that  would do us fine for anything we need to do here.

Would we be in compliance if we had 8 or 10  SQLStandard instances running in VMs on the same 2 processor ESX box?  If not what would be our best bet without breaking the bank.  I've been through the licensing docs quite a few time and am thoroughly confused.

I attached one of the docs , "2008 SQL licensing overview final"

 2008-SQL-Licensin-overview-final.docx
0
Comment
Question by:imherson
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 10

Accepted Solution

by:
ChopperCentury earned 84 total points
ID: 34892253
Under per proc licensing you can run as many VM instances of SQL as you like as long as they stay on the same Proc and do not move between machines (VMotion, etc..)
Standard licensing is 1:1 ratio, install it where you want it but only once for each license.
Yes, Microsoft intentionally makes the licensing difficult to understand so you will buy more of the wrong thing and spend more money.
0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 250 total points
ID: 34892266
I don't believe that Enterprise edition will downgrade to standard edition.  You would need to purchase an additional 2 processor license for Standard edition.  Don't quote me on this, but this sounds logical.

Or better...save money and upgrade the Standard edition instances to Enterprise Edition, because you will be supported.

I'm not a license expert either, but I believe the SQL processor licenses are licensed to the physical CPUs.  So any enterprise edition instances running on VMs on the ESX host will be covered by the processor license.
0
 
LVL 1

Assisted Solution

by:sneakanddestroy
sneakanddestroy earned 166 total points
ID: 34892393
You can have as many VM's as you want as long as you stay with the same 2 Procs.  I have attached the license doc so maybe it will be more helpful in the future.
SQLServer2008-LicensingGuide.pdf
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:imherson
ID: 34897070
Does the enterprise version require the "input of CALs" to make connections?  In other words is there a hard stop when a the licenced number of CALs are reached?
0
 
LVL 1

Assisted Solution

by:sneakanddestroy
sneakanddestroy earned 166 total points
ID: 34898506
When you use the proc licensing there is no CAL limit or need for them because CAL is a completely different  type of licensing scheme.  As long as you are using Proc Licensing theoretically you could have an unlimited amount of users as long as the licensed processors can handle them.
0
 

Author Comment

by:imherson
ID: 34898606
Server/ Cal is the the purchase we are considering
0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 250 total points
ID: 34899579
Server with CAL only licenses the installed instance.  You will need to purchase a server license for all VMs.

CALs may be cheaper.  How many clients will be accessing any of the SQL Server instances.  At my last company we went with CALs for our internal databases because we only had 200 employees.  For our web database we had to go with processor licensing.
0
 

Author Comment

by:imherson
ID: 34899877
If I downgrade to plain 2008 ent (not R2) then don't I have unlimited virtualization rights?  I'm getting this from the VIRTUALIZATION AND MULTI-INSTANCING section in the doc
"SQL Server 2008 Pricing and Licensing"
http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20overview%20final.docx

About Server/ CAL licensing, it says, "For Enterprise edition, for each server to which you assign a software license, you may run, at any one time, any number of instances of the server software in one physical and any number of virtual operating system environments on that server. "
0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 250 total points
ID: 34900924
You are correct.  They changed the server/cal # of instances licensing with SQL 2008.
0
 

Author Comment

by:imherson
ID: 35018584
Your comments and those of a ms sales rep confirm ms lic is as clear as mud
0
 

Author Closing Comment

by:imherson
ID: 35018621
In some case we are just making best guesses
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

808 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