SALES: 1-800-867-1380
Microsoft Azure
Collapse the table of content
Expand the table of content
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: May 26, 2016

Applies To: SQL Server 2016

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

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

System_CAPS_ICON_note.jpg Note


To download SQL Server 2016, go to Evaluation Center.

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

To navigate the table for a SQL Server technology, click on its link:

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
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 coresOperating system maximum
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 coresOperating system maximum
Maximum memory utilized per instance of SQL Server Database EngineOperating System Maximum128 GB64 GB1 GB1 GB1 GBOperating System Maximum
Maximum memory utilized per instance of Analysis ServicesOperating System MaximumTabular: 16 GB

MOLAP: 64 GB
N/AN/AN/AN/AOperating System Maximum
Maximum memory utilized per instance of Reporting ServicesOperating System Maximum64 GB64 GB4 GBN/AN/AOperating System Maximum
Maximum relational database size524 PB524 PB524 PB10 GB10 GB10 GB524 PB
  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 ToolsExpressDeveloper
Server core support 1YesYesYesYesYesYesYes
Log shippingYesYesYesNoNoNoYes
Database mirroringYesYes

Full safety only
Witness onlyWitness onlyWitness onlyWitness onlyYes
Backup compressionYesYesYes
Database snapshotYesYes
Always On failover cluster instancesYes

Number of nodes is the operating system maximum
Yes

Support for 2 nodes
Yes

Number of nodes is the operating system maximum
Always On availability groupsYes

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

Support for 2 nodes
Connection directorYesYes
Online page and file restoreYesYes
Online indexingYesYes
Online schema changeYesYes
Fast recoveryYesYes
Mirrored backupsYesYes
Hot add memory and CPUYesYes
Database recovery advisorYesYesYesYesYesYesYes
Encrypted backupYesYesYes
Smart backupYesYesYes

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 ToolsExpressDeveloper
Operational analyticsYesYes
In-Memory Column StoreYesYes
Stretch DatabaseYesYesYesYesYesYesYes
Persistent Main MemoryYesYesYesYesYesYesYes
Multi-instance support50505050505050
Table and index partitioningYesYes
Data compressionYesYes
Resource GovernorYesYes
Partition Table ParallelismYesYes
Multiple Filestream containersYesYes
NUMA Aware and Large Page Memory and Buffer Array AllocationYesYes
Buffer Pool ExtensionYesYesYes
IO Resource GovernanceYesYes
In Memory OLTPYesYes
Delayed DurabilityYesYesYesYesYesYesYes
FeatureEnterpriseStandardWebExpressExpress with Advanced ServicesExpress with ToolsDeveloper
Row-level securityYesYesNoYes
Always EncryptedYesYes
Dynamic data maskingYesYesYes
Basic auditingYesYesYesYesYesYesYes
Fine grained auditingYesYes
Transparent database encryptionYesYes
Extensible key managementYesYes
User-defined rolesYesYesYesYesYesYesYes
Contained databasesYesYesYesYesYesYesYes
Encryption for backupsYesYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Heterogeneous subscribersYesYesYes
Merge replicationYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes
Oracle publishingYesYes
Peer to peer transactional replicationYesYes
Snapshot replicationYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes
SQL Server change trackingYesYesYesYesYesYesYes
Transactional replicationYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes
Transactional replication to AzureYesYesYesYes
Transactional replication updateable subscriptionYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
SQL Management Objects (SMO)YesYesYesYesYesYesYes
SQL Configuration ManagerYesYesYesYesYesYesYes
SQL CMD (Command Prompt tool)YesYesYesYesYesYesYes
SQL Server Management StudioYesYesYesYesYesYes
Distributed Replay - Admin ToolYesYesYesYesYesYes
Distribute Replay - ClientYesYesYesYes
Distributed Replay - ControllerYes (Up to 16 clients)Yes (1 client)Yes (1 client)Yes (1 client)
SQL ProfilerYesYesNo 1No 1No 1No 1Yes
SQL Server AgentYesYesYesYes
Microsoft System Center Operations Manager Management PackYesYesYesYes
Database Tuning Advisor (DTA)YesYes 2Yes 2Yes
Deploy a SQL Server Database to a Windows Azure VM WizardYesYesYesYesYesYesYes
SQL Server Data Files in Windows AzureYesYesYesYesYesYesYes

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 ToolsExpressDeveloper
User instancesYesYesYesYes
LocalDBYesYesYes
Dedicated admin connectionYesYesYesYes with trace flagYes with trace flagYes with trace flagYes
PowerShell scripting supportYesYesYesYesYesYesYes
SysPrep support 1YesYesYesYesYesYesYes
Support for data-tier application component operations - extract, deploy, upgrade, deleteYesYesYesYesYesYesYes
Policy automation (check on schedule and change)YesYesYesYes
Performance data collectorYesYesYesYes
Able to enroll as a managed instance in multi-instance managementYesYesYesYes
Standard performance reportsYesYesYesYes
Plan guides and plan freezing for plan guidesYesYesYesYes
Direct query of indexed views (using NOEXPAND hint)YesYesYesYes
Automatic indexed views maintenanceYesYesYesYes
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 updatableYes
Parallel indexed operationsYesYes
Automatic use of indexed view by query optimizerYesYes
Parallel consistency checkYes
SQL Server Utility Control PointYesYes
Contained databasesYesYesYesYesYesYesYes
Buffer pool extensionYesYesYes

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

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Microsoft Visual Studio integrationYesYesYesYesYesYesYes
Intellisense (Transact-SQL and MDX)YesYesYesYesYesYesYes
SQL Server Data Tools (SSDT)YesYesYesYesYes
SQL query edit and design toolsYesYesYes
Version control supportYesYesYes
MDX edit, debug, and design toolsYesYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Basic R integrationYesYesYesYesYes
Advanced R integrationYesYes
R Server (Standalone)YesYes
Polybase compute nodeYesYesYes
Polybase head nodeYes
JSONYesYesYesYesYesYesYes
Query StoreYesYesYesYesYesYesYes
TemporalYesYesYesYesYesYesYes
Common Language Runtime (CLR) IntegrationYesYesYesYesYesYesYes
Native XML supportYesYesYesYesYesYesYes
XML indexingYesYesYesYesYesYesYes
MERGE & UPSERT capabilitiesYesYesYesYesYesYesYes
FILESTREAM supportYesYesYesYesYesYesYes
FileTableYesYesYesYesYesYesYes
Date and Time datatypesYesYesYesYesYesYesYes
Internationalization supportYesYesYesYesYesYesYes
Full-text and semantic searchYesYesYesYesYes
Specification of language in queryYesYesYesYesYes
Service Broker (messaging)YesYesNo (Client only)No (Client only)No (Client only)No (Client only)Yes
Transact-SQL endpointsYesYesYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
SQL Server Import and Export WizardYesYesYesYesYesYesYes
Built-in data source connectorsYesYesYesYesYesYesYes
Azure data source connectors and tasksYesYesYesYesYesYesYes
Hadoop / HDFS connectors and tasksYesYesYesYes
SSIS Designer and runtimeYesYesYes
Built in tasks and transformationsYesYesYes
Basic data profiling toolsYesYesYes
Change Data Capture Service for Oracle by AttunityYesYes
Change Data Capture Designer for Oracle by AttunityYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
High performance Oracle destinationYesYes
High performance Teradata DestinationYesYes
SAP BW source and destinationYesYes
Data mining model training destination adapterYesYes
Dimension processing destination adapterYesYes
Partition processing destination adapterYesYes
Change Data Capture components by AttunityYesYes
Connector for Open Database Connectivity (ODBC) by AttunityYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Persistent (high performance) lookupsYesYes
Data mining query transformationYesYes
Fuzzy grouping and lookup transformationsYesYes
Term extractions and lookup transformationsYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Master Data Services databaseYesYes
Master Data Manager web applicationYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Create cubes without a databaseYesYesYes
Auto-generate staging and data warehouse schemaYesYesYes
Change data captureYesYes
Star join query optimizationsYesYes
Scalable read-only Analysis Services configurationYesYes
Parallel query processing on partitioned tables and indexesYesYes
xVelocity memory optimized columnstore indexesYesYes
Global batch aggregationYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Scalable shared databasesYesYes
Backup/Restore & Attach/Detach databasesYesYesYes
Synchronize databasesYesYes
Always On failover cluster instancesYes

Number of nodes is the operating system maximum
Yes

Support for 2 nodes
Yes

Number of nodes is the operating system maximum
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL, TMSL)YesYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Semi-additive measuresYesNo 1Yes
HierarchiesYesYesYes
KPIsYesYesYes
PerspectivesYesYes
ActionsYesYesYes
Account intelligenceYesYesYes
Time intelligenceYesYesYes
Custom rollupsYesYesYes
Writeback cubeYesYesYes
Writeback dimensionsYesYes
Writeback cellsYesYesYes
DrillthroughYesYesYes
Advanced hierarchy types (parent-child and ragged hierarchies)YesYesYes
Advanced dimensions (reference dimensions, many-to-many dimensions)YesYesYes
Linked measures and dimensionsYesYes
TranslationsYesYesYes
AggregationsYesYesYes
Multiple partitionsYesYes, up to 3Yes
Proactive cachingYesYes
Custom assemblies (stored procedures)YesYesYes
MDX queries and scriptsYesYesYes
DAX queriesYesYesYes
Role-based security modelYesYesYes
Dimension and cell-level securityYesYesYes
Scalable string storageYesYesYes
MOLAP, ROLAP, and HOLAP storage modelsYesYesYes
Binary and compressed XML transportYesYesYes
Push-mode processingYesYes
Direct writebackYesYes
Measure expressionsYesYes

1 The LastChild semi-additive measure is supported in Standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.

FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
HierarchiesYesYesYes
KPIsYesYesYes
PerspectivesYesYes
TranslationsYesYesYes
DAX calculations, DAX queries, MDX queriesYesYesYes
Row-level securityYesYesYes
Multiple partitionsYesYes
In-memory storage modeYesYesYes
DirectQuery storage modeYesYes
FeatureEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
SharePoint farm integration based on shared service architectureYesYes
Usage reportingYesYes
Health monitoring rulesYesYes
Power Pivot galleryYesYes
Power Pivot data refreshYesYes
Power Pivot data feedsYesYes
Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Standard algorithmsYesYesYes
Data mining tools (Wizards, Editors, Query Builders)YesYesYes
Cross validationYesYes
Models on filtered subsets of mining structure dataYesYes
Time series: Custom blending between ARTXP and ARIMA methodsYesYes
Time series: Prediction with new dataYesYes
Unlimited concurrent DM queriesYesYes
Advanced configuration & tuning options for data mining algorithmsYesYes
Support for plug-in algorithmsYesYes
Parallel model processingYesYes
Time series: cross-series predictionYesYes
Unlimited attributes for association rulesYesYes
Sequence predictionYesYes
Multiple prediction targets for naïve Bayes, neural network and logistic regressionYesYes
Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Mobile reports and KPIsYesYes
Supported catalog DB SQL Server editionStandard or higherStandard or higherWebExpressStandard or higher
Supported data source SQL Server editionAll SQL Server editionsAll SQL Server editionsWebExpressAll SQL Server editions
Report serverYesYesYesYesYes
Report designerYesYesYesYesYes
Report designer web portalYesYesYesYesYes
Role based securityYesYesYesYesYes
Export to Excel, PowerPoint, Word, PDF, and imagesYesYesYesYesYes
Enhanced gauges and chartingYesYesYesYesYes
Pin report items to Power BIdashboardsYesYesYesYesYes
Custom authenticationYesYesYesYesYes
Report as data feedsYesYesYesYesYes
Model supportYesYesYesYes
Create custom roles for role-based securityYesYesYes
Model Item securityYesYesYes
Infinite click throughYesYesYes
Shared component libraryYesYesYes
Email and file share subscriptions and schedulingYesYesYes
Report history, execution snapshots and cachingYesYesYes
SharePoint IntegrationYesYesYes
Remote and non-SQL data source support1YesYesYes
Data source, delivery and rendering, RDCE extensibilityYesYesYes
Custom brandingYesYes
Data driven report subscriptionYesYes
Scale out deployment (Web farms)YesYes
Alerting2YesYes
Power View 2YesYes

1 For more information on supported datasources in SQL Server 2016 Reporting Services (SSRS), see Data Sources Supported by Reporting Services (SSRS).

2 Requires Reporting Services in SharePoint mode. For more information, see Install Reporting Services SharePoint Mode.

When creating a report server database, not all editions of SQL Server can be used to host the database. The following table shows you which editions of the Database Engine you can use for specific editions of Reporting Services.

For this edition of SQL Server Reporting ServicesUse this edition of the Database Engine instance to host the database
EnterpriseEnterprise, or Standard editions (local or remote)
StandardEnterprise, or Standard editions (local or remote)
WebWeb edition (local only)
Express with Advanced ServicesExpress with Advanced Services (local only).
EvaluationEvaluation

The following software client applications are available on the Microsoft Download center and are provided to assist you with creating business intelligence documents that run on a SQL Server instance. When you host these documents in a server environment, use an edition of SQL Server that supports that document type. The following table identifies which SQL Server edition contains the server features required to host the documents created in these client applications.

Tool NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Report Builder (.rdlx)YesYesYes
Data Mining Add-ins for Excel and Visio 2010 (.xlsx, .vsdx)YesYesYes
Power Pivot for Excel 2010 and 2013 (.xlsx)YesYes
Master Data Services Add-in for Excel (.xlsx)YesYes
SQL Server Mobile Report Publisher (.rsmobile)YesYes
Power BI apps for mobile devices (iOS, Windows 10, Android) (.rsmobile)YesYes
System_CAPS_ICON_note.jpg Note

  1. Power Pivot for Excel is an Excel add-in for creating workbooks with a data model. Power Pivot for Excel does not depend on SQL Server, but Power Pivot for SharePoint is required for sharing and collaborating on Excel workbooks with a data model in SharePoint. This capability is available as part of SQL Server Enterprise edition.

    In Excel 2016, Power Pivot capability is built in, so you no longer need the Power Pivot add-in.

  2. The above table identifies the SQL Server editions that are required to enable these client tools; however these tools can access data hosted on any edition of SQL Server.

  3. SQL Server Mobile Report Publisher is the single point for creation of mobile reports. Connect to a Reporting Services server to access data sources and create reports. Then publish them to the Reporting Services server for others in the organization to access, either on the server or on mobile devices. You can also use SQL Server Mobile Report Publisher stand alone with local data sources

  4. Whether you are using SQL Server 2016 Reporting Services (SSRS) on-premises, Power BI in the cloud, or both as your report delivery solution you only need one mobile app to access dashboards and mobile reports on mobile devices. The Power BI apps are available for download from the Windows, iOS, or Android app stores.

Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Spatial indexesYesYesYesYesYesYesYes
Planar and geodetic datatypesYesYesYesYesYesYesYes
Advanced spatial librariesYesYesYesYesYesYesYes
Import/export of industry-standard spatial data formatsYesYesYesYesYesYesYes
Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
SQL Server Migration AssistantYesYesYesYesYesYesYes
Database mailYesYesYesYes
Feature NameEnterpriseStandardWebExpress with Advanced ServicesExpress with ToolsExpressDeveloper
Data Quality ServicesYesYes
StreamInsightStreamInsight Premium EditionStreamInsight Standard EditionStreamInsight Standard EditionStreamInsight Premium Edition
StreamInsight HAStreamInsight Premium EditionStreamInsight Premium Edition

Product Specifications for SQL Server 2016
Installation for SQL Server 2016

Show:
© 2016 Microsoft