Description

SQL Server 2016 includes more features than ever before, but it can be difficult to find the differences between versions of SQL Server.

The primary difference is the licensing model, which limits how SQL Server may be used on the server it is installed on. A majority of SQL Server features are available in both SQL Server Web and Standard editions. There are some differences around mirroring (Web can only serve as a witness), publishing (Web can only subscribe), and performance (Web does not come with SQL Profiler).

Detail Steps

SQL Server Versions

SQL Server editionDefinition
EnterpriseThe premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user access to data insights.
StandardSQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources.
WebSQL Server Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.

SQL Server Licensing

SQL Server editionLicensing Format
EnterpriseLicensed per User (CAL) or per CPU. Each license (User CAL) covers one authorized user who will access the database server. It is required to license all users who will have access to the database server. Alternatively, “unlimited” license may be purchased per CPU. It is required to license all CPUs on the server where SQL Server is running. 
StandardLicensed per User. Each license (User CAL) covers one authorized user who will access the database server. It is required to license all users who will have access to the database server. 
WebLicensed per 2 CPU cores. Licenses are provided in packs of 2, so 1 license covers 2 CPU cores. It is required to license all cores on the server where SQL Server is running. 

Scale Limits

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress
Maximum compute capacity used by a single instance – SQL Server Database Engine1Operating system maximumLimited to lesser of 4 sockets or 24 coresLimited to lesser of 4 sockets or 16 coresLimited to lesser of 1 socket or 4 coresLimited to lesser of 1 socket or 4 cores
Maximum compute capacity used by a single instance – Analysis Services or Reporting ServicesOperating system maximumLimited to lesser of 4 sockets or 24 coresLimited to lesser of 4 sockets or 16 coresLimited to lesser of 1 socket or 4 coresLimited to lesser of 1 socket or 4 cores
Maximum memory for buffer pool per instance of SQL Server Database EngineOperating System Maximum128 GB64 GB1410 MB1410 MB
Maximum memory for Columnstore segment cache per instance of SQL Server Database EngineUnlimited memory32 GB216 GB2352 MB2352 MB2
Maximum memory-optimized data size per database in SQL Server Database EngineUnlimited memory32 GB216 GB2352 MB2352 MB2
Maximum memory utilized per instance of Analysis ServicesOperating System MaximumTabular: 16 GBMOLAP: 64 GBN/AN/AN/A
Maximum memory utilized per instance of Reporting ServicesOperating System Maximum64 GB64 GB4 GBN/A
Maximum relational database size524 PB524 PB524 PB10 GB10 GB

1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. There are no limits under the Core-based Server Licensing model. For more information, see Compute Capacity Limits by Edition of SQL Server.

2 Applies to SQL Server 2016 SP1.

Related Information

Source: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016

Visit docs.microsoft.com for up-to-date documentation on Microsoft SQL Server 2016.