Solved

core based SQL server?

Posted on 2013-06-10
8
339 Views
Last Modified: 2013-06-12
I saw an sql server that was standard and another that was standard "core-based".   What is the difference between these two types of SQL servers?
0
Comment
Question by:al4629740
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 100 total points
ID: 39236370
I am not sure but you probably are referring to installing SQL Server over a regular Windows server installation as opposed to installing SQL Server on a windows core installation.  A windows core installation allows SQL Server to run on the top of an operating systems stripped down of all functionnalities that are unnecessary for SQL Server to be able to run.  Functionalities include visual interfacing at first.  The result of such stripping down is to lighten the windows platform hence to improve SQL Server performance.
0
 
LVL 22

Assisted Solution

by:Thomasian
Thomasian earned 200 total points
ID: 39236649
SQL Server 2012 Standard has 2 types of licensing, "Server+CAL" or "Per Core". The features are the same, the only difference is how you pay for the license.

Read the licensing guide for more info: http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf
0
 

Author Comment

by:al4629740
ID: 39236840
Does one have better performance over the other?
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 22

Assisted Solution

by:Thomasian
Thomasian earned 200 total points
ID: 39236858
No. They are the same. The only difference is the licensing model.

For "Per Core" licensing, you license each core running SQL Server.
For "Server + CAL" licensing, you have to license each server plus another license for each user/device (CAL). CAL stands for Client Access License.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39236966
OK so perhaps this was about licensing.  Licensing has nothing to do with performance and everything with how much money you can put into it .  Look for the most economic solution/
0
 
LVL 13

Assisted Solution

by:jonnidip
jonnidip earned 100 total points
ID: 39237037
Yes, it is about licensing and not about the os type (even if "windows server core" can lead to confusion, in this case).
There is no absolute "most economic solution", since it really depends on your needs.
You should take a look at both licensing types and find yourself what is the best for you.
I also suggest you to contact a vendor, since the prices on the MS website are approx..
Please read this guide: SQL_Server_2012_Licensing_Reference_Guide.pdf

Regards.
0
 

Author Comment

by:al4629740
ID: 39239628
Curious question.  If I just get the normal SQL server and install it what happens if I don't buy enough licenses.  For example lets say that I have only 2 cals and then I have 12 users accessing it?

What happens?
0
 
LVL 35

Accepted Solution

by:
David Todd earned 100 total points
ID: 39239702
Hi,

I believe that it will work until you are audited, and then not only will you have to pay licencing, but likely a fine as well.

Regards
  David
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

803 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