Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Features Supported by the Editions of SQL Server 2016

 

Published: May 26, 2016

Updated: September 2, 2016

Applies To: SQL Server 2016

This topic provides details of features supported by the different editions of SQL Server 2016.

SQL Server Evaluation edition is available for a 180-day trial period.

For the latest release notes, see SQL Server 2016 Release Notes. For the latest information on what is new, see What's New in SQL Server 2016.

Try SQL Server 2016!

Download from Evaluation Center Download SQL Server 2016 from the Evaluation Center

Azure Virtual Machine small Spin up a Virtual Machine with SQL Server 2016 already installed

For features supported by Evaluation and Developer editions see SQL Server Enterprise Edition.

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
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 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 coresLimited to lesser of 1 socket or 4 cores
Maximum memory utilized per instance of SQL Server Database EngineOperating System Maximum128 GB64 GB1 GB1 GB1 GB
Maximum memory utilized per instance of Analysis ServicesOperating System MaximumTabular: 16 GB

MOLAP: 64 GB
N/AN/AN/AN/A
Maximum memory utilized per instance of Reporting ServicesOperating System Maximum64 GB64 GB4 GBN/AN/A
Maximum relational database size524 PB524 PB524 PB10 GB10 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.
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Server core support 1YesYesYesYesYesYes
Log shippingYesYesYesNoNoNo
Database mirroringYesYes

Full safety only
Witness onlyWitness onlyWitness onlyWitness only
Backup compressionYesYes
Database snapshotYes
Always On failover cluster instancesYes

Number of nodes is the operating system maximum
Yes

Support for 2 nodes
Always On availability groupsYes

Up to 8 secondary replicas, including 2 synchronous secondary replicas
Basic availability groupsYes

Support for 2 nodes
Connection directorYes
Online page and file restoreYes
Online indexingYes
Online schema changeYes
Fast recoveryYes
Mirrored backupsYes
Hot add memory and CPUYes
Database recovery advisorYesYesYesYesYesYes
Encrypted backupYesYes
Smart backupYesYes

1 For more information on installing SQL Server 2016 on Server Core, see Install SQL Server 2016 on Server Core.

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Operational analyticsYes
In-Memory Column StoreYes
Stretch DatabaseYesYesYesYesYesYes
Persistent Main MemoryYesYesYesYesYesYes
Multi-instance support505050505050
Table and index partitioningYes
Data compressionYes
Resource GovernorYes
Partition Table ParallelismYes
Multiple Filestream containersYes
NUMA Aware and Large Page Memory and Buffer Array AllocationYes
Buffer Pool ExtensionYesYes
IO Resource GovernanceYes
In Memory OLTPYes
Delayed DurabilityYesYesYesYesYesYes
FeatureEnterpriseStandardWebExpressExpress with Advanced ServicesExpress with Tools
Row-level securityYesYesNo
Always EncryptedYes
Dynamic data maskingYesYes
Basic auditingYesYesYesYesYesYes
Fine grained auditingYes
Transparent database encryptionYes
Extensible key managementYes
User-defined rolesYesYesYesYesYesYes
Contained databasesYesYesYesYesYesYes
Encryption for backupsYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Heterogeneous subscribersYesYes
Merge replicationYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Oracle publishingYes
Peer to peer transactional replicationYes
Snapshot replicationYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
SQL Server change trackingYesYesYesYesYesYes
Transactional replicationYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Transactional replication to AzureYesYesYes
Transactional replication updateable subscriptionYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Management Objects (SMO)YesYesYesYesYesYes
SQL Configuration ManagerYesYesYesYesYesYes
SQL CMD (Command Prompt tool)YesYesYesYesYesYes
SQL Server Management StudioYesYesYesYesYes
Distributed Replay - Admin ToolYesYesYesYesYes
Distribute Replay - ClientYesYesYes
Distributed Replay - ControllerYes (Up to 16 clients)Yes (1 client)Yes (1 client)
SQL ProfilerYesYesNo 1No 1No 1No 1
SQL Server AgentYesYesYes
Microsoft System Center Operations Manager Management PackYesYesYes
Database Tuning Advisor (DTA)YesYes 2Yes 2
Deploy a SQL Server Database to a Windows Azure VM WizardYesYesYesYesYesYes
SQL Server Data Files in Windows AzureYesYesYesYesYesYes

1 SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.

2 Tuning enabled only on Standard edition features

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
User instancesYesYesYes
LocalDBYesYes
Dedicated admin connectionYesYesYesYes with trace flagYes with trace flagYes with trace flag
PowerShell scripting supportYesYesYesYesYesYes
SysPrep support 1YesYesYesYesYesYes
Support for data-tier application component operations - extract, deploy, upgrade, deleteYesYesYesYesYesYes
Policy automation (check on schedule and change)YesYesYes
Performance data collectorYesYesYes
Able to enroll as a managed instance in multi-instance managementYesYesYes
Standard performance reportsYesYesYes
Plan guides and plan freezing for plan guidesYesYesYes
Direct query of indexed views (using NOEXPAND hint)YesYesYes
Automatic indexed views maintenanceYesYesYes
Distributed partitioned viewsYesPartial. Distributed partitioned views are not updatablePartial. Distributed partitioned views are not updatablePartial. Distributed partitioned views are not updatablePartial. Distributed partitioned views are not updatablePartial. Distributed partitioned views are not updatable
Parallel indexed operationsYes
Automatic use of indexed view by query optimizerYes
Parallel consistency checkYes
SQL Server Utility Control PointYes
Contained databasesYesYesYesYesYesYes
Buffer pool extensionYesYes

1 For more information, see Considerations for Installing SQL Server Using SysPrep.

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Microsoft Visual Studio integrationYesYesYesYesYesYes
Intellisense (Transact-SQL and MDX)YesYesYesYesYesYes
SQL Server Data Tools (SSDT)YesYesYesYes
SQL query edit and design toolsYesYes
Version control supportYesYes
MDX edit, debug, and design toolsYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Basic R integrationYesYesYesYes
Advanced R integrationYes
R Server (Standalone)Yes
Polybase compute nodeYesYes
Polybase head nodeYes
JSONYesYesYesYesYesYes
Query StoreYesYesYesYesYesYes
TemporalYesYesYesYesYesYes
Common Language Runtime (CLR) IntegrationYesYesYesYesYesYes
Native XML supportYesYesYesYesYesYes
XML indexingYesYesYesYesYesYes
MERGE & UPSERT capabilitiesYesYesYesYesYesYes
FILESTREAM supportYesYesYesYesYesYes
FileTableYesYesYesYesYesYes
Date and Time datatypesYesYesYesYesYesYes
Internationalization supportYesYesYesYesYesYes
Full-text and semantic searchYesYesYesYes
Specification of language in queryYesYesYesYes
Service Broker (messaging)YesYesNo (Client only)No (Client only)No (Client only)No (Client only)
Transact-SQL endpointsYesYesYes

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.

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.

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Create cubes without a databaseYesYes
Auto-generate staging and data warehouse schemaYesYes
Change data captureYes
Star join query optimizationsYes
Scalable read-only Analysis Services configurationYes
Parallel query processing on partitioned tables and indexesYes
xVelocity memory optimized columnstore indexesYes
Global batch aggregationYes

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.

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.

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.

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.

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.

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.

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.

Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Spatial indexesYesYesYesYesYesYes
Planar and geodetic datatypesYesYesYesYesYesYes
Advanced spatial librariesYesYesYesYesYesYes
Import/export of industry-standard spatial data formatsYesYesYesYesYesYes
Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server Migration AssistantYesYesYesYesYesYes
Database mailYesYesYes
Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpress
StreamInsightStreamInsight Premium EditionStreamInsight Standard EditionStreamInsight Standard Edition
StreamInsight HAStreamInsight Premium Edition

Download SSMS Download the latest version of SQL Server Management Studio

Product Specifications for SQL Server 2016
Installation for SQL Server 2016

Community Additions

Show: