[SQL2016] Editions and Supported Features for SQL Server 2016

/*******************************************************************************************************************
-- Title : [SQL2016] Editions and Supported Features for SQL Server 2016
-- Reference : microsoft.com
-- Key word : sql server 2016 edition new feature 에디션 지원 기능 enterprise standard 버전 릴리스
                  version release
*******************************************************************************************************************/

-- Link
    * https://msdn.microsoft.com/ko-kr/library/cc645993.aspx
    * https://msdn.microsoft.com/en-us/library/cc645993.aspx

-- Scale Limits

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Maximum compute capacity used by a single instance - SQL Server Database Engine1	Operating system maximum	Limited to lesser of 4 sockets or 24 cores	Limited to lesser of 4 sockets or 16 cores	Limited to lesser of 1 socket or 4 cores	Limited to lesser of 1 socket or 4 cores
Maximum compute capacity used by a single instance - Analysis Services or Reporting Services	Operating system maximum	Limited to lesser of 4 sockets or 24 cores	Limited to lesser of 4 sockets or 16 cores	Limited to lesser of 1 socket or 4 cores	Limited to lesser of 1 socket or 4 cores
Maximum memory for buffer pool per instance of SQL Server Database Engine	Operating System Maximum	128 GB	64 GB	1410 MB	1410 MB
Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine	Unlimited memory	32 GB2	16 GB2	352 MB2	352 MB2
Maximum memory-optimized data size per database in SQL Server Database Engine	Unlimited memory	32 GB2	16 GB2	352 MB2	352 MB2
Maximum memory utilized per instance of Analysis Services	Operating System Maximum	Tabular: 16 GB MOLAP: 64 GB	N/A	N/A	N/A
Maximum memory utilized per instance of Reporting Services	Operating System Maximum	64 GB	64 GB	4 GB	N/A
Maximum relational database size	524 PB	524 PB	524 PB	10 GB	10 GB

-- RDBMS High Availability

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Server core support 1	Yes	Yes	Yes	Yes	Yes
Log shipping	Yes	Yes	Yes	No	No
Database mirroring	Yes	Yes Full safety only	Witness only	Witness only	Witness only
Backup compression	Yes	Yes	No	No	No
Database snapshot	Yes	Yes 3	Yes 3	Yes 3	Yes 3
Always On failover cluster instances	Yes Number of nodes is the operating system maximum	Yes Support for 2 nodes	No	No	No
Always On availability groups	Yes Up to 8 secondary replicas, including 2 synchronous secondary replicas	No	No	No	No
Basic availability groups 2	No	Yes Support for 2 nodes	No	No	No
Connection director	Yes	No	No	No	No
Online page and file restore	Yes	No	No	No	No
Online indexing	Yes	No	No	No	No
Online schema change	Yes	No	No	No	No
Fast recovery	Yes	No	No	No	No
Mirrored backups	Yes	No	No	No	No
Hot add memory and CPU	Yes	No	No	No	No
Database recovery advisor	Yes	Yes	Yes	Yes	Yes
Encrypted backup	Yes	Yes	No	No	No
Hybrid backup to Windows Azure (backup to URL)	Yes	Yes	No	No	No

-- RDBMS Scalability and Performance

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Columnstore 1	Yes	Yes 2	Yes 2	Yes2	Yes2
In-Memory OLTP 1	Yes	Yes 2	Yes 2	Yes 2, 3	Yes 2
Stretch Database	Yes	Yes	Yes	Yes	Yes
Persistent Main Memory	Yes	Yes	Yes	Yes	Yes
Multi-instance support	50	50	50	50	50
Table and index partitioning	Yes	Yes 2	Yes 2	Yes 2	Yes 2
Data compression	Yes	Yes 2	Yes 2	Yes 2	Yes 2
Resource Governor	Yes	No	No	No	No
Partitioned Table Parallelism	Yes	No	No	No	No
Multiple Filestream containers	Yes	Yes 2	Yes 2	Yes 2	Yes 2
NUMA Aware and Large Page Memory and Buffer Array Allocation	Yes	No	No	No	No
Buffer Pool Extension	Yes	Yes	No	No	No
IO Resource Governance	Yes	No	No	No	No
Delayed Durability	Yes	Yes	Yes	Yes	Yes

-- RDBMS Security

Feature	Enterprise	Standard	Web	Express	Express with Advanced Services
Row-level security	Yes	Yes	Yes 1	Yes 1	Yes 1
Always Encrypted	Yes	Yes 1	Yes 1	Yes 1	Yes 1
Dynamic data masking	Yes	Yes	Yes 1	Yes 1	Yes 1
Basic auditing	Yes	Yes	Yes	Yes	Yes
Fine grained auditing	Yes	Yes 1	Yes 1	Yes 1	Yes 1
Transparent database encryption	Yes	No	No	No	No
Extensible key management	Yes	No	No	No	No
User-defined roles	Yes	Yes	Yes	Yes	Yes
Contained databases	Yes	Yes	Yes	Yes	Yes
Encryption for backups	Yes	Yes	No	No	No

-- Replication

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Heterogeneous subscribers	Yes	Yes	No	No	No
Merge replication	Yes	Yes	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)
Oracle publishing	Yes	No	No	No	No
Peer to peer transactional replication	Yes	No	No	No	No
Snapshot replication	Yes	Yes	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)
SQL Server change tracking	Yes	Yes	Yes	Yes	Yes
Transactional replication	Yes	Yes	Yes (Subscriber only)	Yes (Subscriber only)	Yes (Subscriber only)
Transactional replication to Azure	Yes	Yes	Yes	No	No
Transactional replication updateable subscription	Yes	No	No	No	No

-- Management Tools

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
SQL Management Objects (SMO)	Yes	Yes	Yes	Yes	Yes
SQL Configuration Manager	Yes	Yes	Yes	Yes	Yes
SQL CMD (Command Prompt tool)	Yes	Yes	Yes	Yes	Yes
Distributed Replay - Admin Tool	Yes	Yes	Yes	Yes	No
Distribute Replay - Client	Yes	Yes	Yes	No	No
Distributed Replay - Controller	Yes (Up to 16 clients)	Yes (1 client)	Yes (1 client)	No	No
SQL Profiler	Yes	Yes	No 1	No 1	No 1
SQL Server Agent	Yes	Yes	Yes	No	No
Microsoft System Center Operations Manager Management Pack	Yes	Yes	Yes	No	No
Database Tuning Advisor (DTA)	Yes	Yes 2	Yes 2	No	No

-- RDBMS Manageability

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
User instances	No	No	No	Yes	Yes
LocalDB	No	No	No	Yes	No
Dedicated admin connection	Yes	Yes	Yes	Yes with trace flag	Yes with trace flag
PowerShell scripting support	Yes	Yes	Yes	Yes	Yes
SysPrep support 1	Yes	Yes	Yes	Yes	Yes
Support for data-tier application component operations - extract, deploy, upgrade, delete	Yes	Yes	Yes	Yes	Yes
Policy automation (check on schedule and change)	Yes	Yes	Yes	No	No
Performance data collector	Yes	Yes	Yes	No	No
Able to enroll as a managed instance in multi-instance management	Yes	Yes	Yes	No	No
Standard performance reports	Yes	Yes	Yes	No	No
Plan guides and plan freezing for plan guides	Yes	Yes	Yes	No	No
Direct query of indexed views (using NOEXPAND hint)	Yes	Yes	Yes	Yes	Yes
Automatic indexed views maintenance	Yes	Yes	Yes	No	No
Distributed partitioned views	Yes	No	No	No	No
Parallel indexed operations	Yes	No	No	No	No
Automatic use of indexed view by query optimizer	Yes	No	No	No	No
Parallel consistency check	Yes	No	No	No	No
SQL Server Utility Control Point	Yes	No	No	No	No
Buffer pool extension	Yes	Yes	No	No	No

-- Development Tools

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Microsoft Visual Studio integration	Yes	Yes	Yes	Yes	Yes
Intellisense (Transact-SQL and MDX)	Yes	Yes	Yes	Yes	Yes
SQL Server Data Tools (SSDT)	Yes	Yes	Yes	Yes	No
MDX edit, debug, and design tools	Yes	Yes	No	No	No

-- Programmability

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Basic R integration	Yes	Yes	Yes	Yes	No
Advanced R integration	Yes	No	No	No	No
R Server (Standalone)	Yes	No	No	No	No
Polybase compute node	Yes	Yes 1	Yes 1, 2	Yes 1, 2	Yes 1, 2
Polybase head node	Yes	No	No	No	No
JSON	Yes	Yes	Yes	Yes	Yes
Query Store	Yes	Yes	Yes	Yes	Yes
Temporal	Yes	Yes	Yes	Yes	Yes
Common Language Runtime (CLR) Integration	Yes	Yes	Yes	Yes	Yes
Native XML support	Yes	Yes	Yes	Yes	Yes
XML indexing	Yes	Yes	Yes	Yes	Yes
MERGE & UPSERT capabilities	Yes	Yes	Yes	Yes	Yes
FILESTREAM support	Yes	Yes	Yes	Yes	Yes
FileTable	Yes	Yes	Yes	Yes	Yes
Date and Time datatypes	Yes	Yes	Yes	Yes	Yes
Internationalization support	Yes	Yes	Yes	Yes	Yes
Full-text and semantic search	Yes	Yes	Yes	Yes	No
Specification of language in query	Yes	Yes	Yes	Yes	No
Service Broker (messaging)	Yes	Yes	No (Client only)	No (Client only)	No (Client only)
Transact-SQL endpoints	Yes	Yes	Yes	No	No

-- Integration Services
For info about the Integration Services (SSIS) features supported by the editions of SQL Server 2016, see Integration Services Features Supported by the Editions of SQL Server 2016.

-- Master Data Services
For information about the Master Data Services and Data Quality Services features supported by the editions of SQL Server 2016, see Master Data Services and Data Quality Services Features Supported by the Editions of SQL Server 2016.

-- Data Warehouse

Feature	Enterprise	Standard	Web	Express with Advanced Services	Express
Create cubes without a database	Yes	Yes	No	No	No
Auto-generate staging and data warehouse schema	Yes	Yes	No	No	No
Change data capture	Yes	Yes 1	Yes 1	No	No
Star join query optimizations	Yes	No	No	No	No
Scalable read-only Analysis Services configuration	Yes	No	No	No	No
Parallel query processing on partitioned tables and indexes	Yes	No	No	No	No
Global batch aggregation	Yes	No	No	No	No

-- Analysis Services
For information about the Analysis Services features supported by the editions of SQL Server 2016, see Analysis Services Features Supported by the Editions of SQL Server 2016.

-- BI Semantic Model (Multi Dimensional)
For information about the Analysis Services features supported by the editions of SQL Server 2016, see Analysis Services Features Supported by the Editions of SQL Server 2016.

-- BI Semantic Model (Tabular)
For information about the Analysis Services features supported by the editions of SQL Server 2016, see Analysis Services Features Supported by the Editions of SQL Server 2016.

-- Power Pivot for SharePoint
For information about the Power Pivot for SharePoint features supported by the editions of SQL Server 2016, see Analysis Services Features Supported by the Editions of SQL Server 2016.

-- Data Mining
For information about the Data Mining features supported by the editions of SQL Server 2016, see Analysis Services Features Supported by the Editions of SQL Server 2016.

-- Reporting Services
For information about the Reporting Services features supported by the editions of SQL Server 2016, see Reporting Services Features Supported by the Editions of SQL Server 2016.

-- Business Intelligence Clients
For information about the Business Intelligence Client features supported by the editions of SQL Server 2016, see Analysis Services Features Supported by the Editions of SQL Server 2016 or Reporting Services Features Supported by the Editions of SQL Server 2016.

-- Spatial and Location Services

Feature Name	Enterprise	Standard	Web	Express with Advanced Services	Express
Spatial indexes	Yes	Yes	Yes	Yes	Yes
Planar and geodetic datatypes	Yes	Yes	Yes	Yes	Yes
Advanced spatial libraries	Yes	Yes	Yes	Yes	Yes
Import/export of industry-standard spatial data formats	Yes	Yes	Yes	Yes	Yes

-- Additional Database Services

Feature Name	Enterprise	Standard	Web	Express with Advanced Services	Express
SQL Server Migration Assistant	Yes	Yes	Yes	Yes	Yes
Database mail	Yes	Yes	Yes	No	No

-- Other Components

Feature Name	Enterprise	Standard	Web	Express with Advanced Services	Express
StreamInsight	StreamInsight Premium Edition	StreamInsight Standard Edition	StreamInsight Standard Edition	No	No
StreamInsight HA	StreamInsight Premium Edition	No	No	No	No