Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2012 license

Posted on 2014-02-21
7
Medium Priority
?
565 Views
Last Modified: 2014-02-27
There are two copy of SQL 2012 server for download,

SQL Server 2012 standard Edition SP1 - Per Core
SQL Server 2012 standard edition SP1 - Server/CAL

What's the different between -Server and Per Core ? Tks
0
Comment
Question by:AXISHK
  • 3
  • 3
7 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39876279
With Server/CAL licensing you licence SQL Server to run on server, and buy CALs for each user who will access it. With the Core licencing model you licence SQL Server based on the number of cores on the machine (or VM) on which it will run - in this case you can have as many connections as you like and don't need to have CALs for individual users.

Which licencing model you need will depend on what you intend to do with it, and the number of users who will be accessing the SQL Server.

If you need Server/CAL licencing then there is a tipping point where it becomes cheaper to go with the Core model instead. Microsoft provide a calculator to help determine where that point is.
0
 

Author Comment

by:AXISHK
ID: 39876340
A server with 1 physical and 8 cores. Should i go for server liccnse or cores licenses.

tks
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39876345
What are you planning to use the SQL Server for, and how many users will need to access it?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

Author Comment

by:AXISHK
ID: 39876362
200 users
0
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 1000 total points
ID: 39876399
200 users puts you into the area where it might be cheaper to go with core licensing. You can find a simplified overview of the licencing models here:

http://blogs.technet.com/b/uspartner_ts2team/archive/2011/11/30/a-concise-sql-server-2012-licensing-overview.aspx

But I would suggest you speak to Microsoft directly about your requirements as they are best placed to give you your options and specific dollar values of each.
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 1000 total points
ID: 39876528
0
 

Author Closing Comment

by:AXISHK
ID: 39893614
Tks
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

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…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

885 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