Solved

SQL 2012 Standard licensing and cost

Posted on 2015-01-08
4
226 Views
Last Modified: 2015-01-23
Hi, I would like to know how to license SQL 2012 Standard edition for our VM environment, we currently have three PowerEdge R620 Servers, each has 2 processors with total 24 cores, one of these server will be running sql 2012 standard, there will be 145 users access the sql database.  What is the best way to license and cost saving?

Thank You!
0
Comment
Question by:amdj
  • 2
4 Comments
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 200 total points
ID: 40538611
Hi,

Who would you buy your SQL Server licences from? They would have a licencing helpdesk that should be able to assist.

Generally you need to do the maths three or four ways - per user/per core/per physical machine. Now I say this because some of the enterprise editions (SQL/Windows) allow you to licence the entire physical machine, and an unlimited number of VM's on the machine.

You haven't specified the VM's. Generally for Standard Edition you have to licence each VM separately. That is, if the VM has 5 cores then that's what you need to licence.

In the past, 50 users has been the cut-over between per user and per socket.

HTH
  David
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 300 total points
ID: 40539984
The SQL Server Standard Edition permits you to chose between the Server+CAL and Per Core licensing.

1. Server+CAL

License users and/or devices. Has low cost access and it's good for incremental SQL Server deployments.

2. Per core

Core based licensing. Appropriate when you are unable to count users/devices, have Internet/Extranet workloads or systems that integrate with external facing workloads. To license a physical server, it must license all the cores in the server.
The Standard Edition has a limit of 16 cores, so means that if you chose the Per Core licensing you'll pay 24 cores but only able to use 16 cores.
0
 

Author Comment

by:amdj
ID: 40540601
@Vitor, so the 16 cores limit is per processor or it doesn't care how many processors in the system?

Great info. guys!
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 40540626
16 cores is the limit for SQL Server Standard Edition. With Enterprise Edition there's no cores limit.
Now, your server has 2 CPU and 24 cores. Those 24 cores are with or without hyper-threading? Because if it's with then I think it only counts 12 cores for licensing.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now