Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
The Trade-off Between SQL Server Security and Performance - Free Webinar
 

Deciding Between Editions of SQL Server for Production


By:   |   Last Updated: 2018-08-23   |   Comments (1)   |   Related Tips: More > Database Administration

Problem

You're asked to run a project that uses SQL Server as the database engine in your production environment with the least cost as possible. You know there are different editions of SQL Server, but how do you choose the right edition to make sure you have the needed features and keep the cost down.

Solution

Decisions are hard to make, especially if you don’t have relevant information. Sometimes the person that makes the decisions is not the person who knows the most. Let’s face it. We as database administrators don’t have the last word in the enterprise world. Not even regarding databases. The one with the last word is the one who signs the pay check, which in most cases is not the DBA.

Just to show you the picture, imagine yourself in a meeting with your company’s CFO explaining to him/her that you need the Enterprise edition of SQL Server. When your CTO asks about the price difference between the 2-pack of core licenses of SQL Server Enterprise $14,256 ($7,128 per core) and the Standard Edition which costs significantly less $3,717 ($1,859 per core) you must provide him with all the information in order to justify the $10,539 difference.

Editions of SQL Server

There are five editions of SQL Server:

  • Express: This is the most basic of all SQL Server editions. It’s free to use in production, which makes it the best choice for independent software vendors, whose clients can’t afford the cost of a SQL Server license.
  • Web: This edition is between the Standard and Express editions. It has features that Web hosting companies and Web VAPs can offer their customers to provide scalability, affordability, and manageability capabilities for small to large scale web properties.
  • Standard: This edition enables database management with minimal IT resources.
  • Enterprise: This is the most complete edition of all. With this edition you have unlimited virtualization and high service levels for mission critical workload.
  • Developer: This edition has all the features of the Enterprise edition, but cannot be used in production environments.

These editions differ on features and also the resources they can utilize based on resource caps that are part of the edition.

Reasons to use SQL Server Express Edition

  • If your application runs fine when capped to the lesser of 1 socket or 4 cores.
  • Your application needs less than 1410 MB of buffer pool and less than 352 MB of memory for both Columnstore segment cache per instance and memory-optimized data size per database.
  • If your database won’t be greater than 10 GB.

Recently I wrote the tip, Deciding to use SQL Server 2017 Express Edition that goes deeper into this matter and SQL Server Express Versions that will help you decide which version of SQL Server Express is right for you.

Reasons to use SQL Server Web Edition

Reasons to use SQL Server Standard Edition

Reasons to use SQL Server Enterprise Edition

Next Steps


Last Updated: 2018-08-23


next webcast button


next tip button



About the author
MSSQLTips author Daniel Farina Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Thursday, August 23, 2018 - 10:11:46 AM - Steven Taub Back To Top

Great article, gang.

But you left out information on the developer edition.  And I think if your goal is to learn sql server, go with the developer edition, since it has more features.


Learn more about SQL Server tools