Solved

SQL licensing options

Posted on 2011-02-14
11
483 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Present Absent from working date rage 11 49
sql query 5 44
the way to learn Microsoft BI 13 51
T-SQL: problem comparing datetime 4 51
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…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 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