?
Solved

core based SQL server?

Posted on 2013-06-10
8
Medium Priority
?
345 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
[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
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 400 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 800 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 800 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 400 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 400 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

752 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