?
Solved

SQL Server 2012 license

Posted on 2014-02-21
7
Medium Priority
?
578 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 

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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

584 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