Solved

SQL licensing options

Posted on 2011-02-14
11
481 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
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

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 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