• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

core based SQL server?

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
al4629740
Asked:
al4629740
  • 2
  • 2
  • 2
  • +2
5 Solutions
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
 
ThomasianCommented:
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
 
al4629740Author Commented:
Does one have better performance over the other?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
ThomasianCommented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
 
jonnidipCommented:
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
 
al4629740Author Commented:
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
 
David ToddSenior DBACommented:
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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now