Solved

SQL licensing options

Posted on 2011-02-14
11
484 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

705 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