Features Supported by the Editions of SQL Server 2014

Features Supported by the Editions of SQL Server 2014

 

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

System_CAPS_ICON_note.jpg Note


SQL Server is available in an Evaluation edition for a 180-day trial period. For more information, see the SQL ServerTrial Software Web Site.

System_CAPS_ICON_note.jpg Note


For features supported by Evaluation and Developer editions see the SQL Server Enterprise feature set.

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

Cross-Box Scale Limits

High Availability

Scalability and Performance

Security

Replication

Management Tools

RDBMS Manageability

Development Tools

Programmability

Integration Services

Integration Services-Advanced Adapters

Integration Services-Advanced Transforms

Master Data Services

Data Warehouse

Analysis Services

BI Semantic Model (Multidimensional)

BI Semantic Model (Tabular)

PowerPivot for SharePoint

Data Mining

Reporting Services

Business Intelligence Clients

Spatial and Location Services

Additional Database Services

Other Components

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1Operating System maximumLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 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, Reporting Services) 1Operating system maximumOperating system maximumLimited to lesser of 4 Sockets or 16 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 Engine)Operating system maximum128 GB128 GB64 GB1 GB1 GB1 GB
Maximum memory utilized (per instance of Analysis Services)Operating system maximumOperating system maximum64 GBN/AN/AN/AN/A
Maximum memory utilized (per instance of Reporting Services)Operating system maximumOperating system maximum64 GB64 GB4 GBN/AN/A
Maximum relational Database size524 PB524 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.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Server Core support1YesYesYesYesYesYesYes
Log ShippingYesYesYesYes
Database mirroringYesYes (Safety Full Only)Yes (Safety Full Only)Witness onlyWitness onlyWitness onlyWitness only
Backup compressionYesYesYes
Database snapshotYes
Alwayson Failover Cluster InstancesYes (Node support: Operating system maximumYes (Node support: 2)Yes (Node support: 2)
AlwaysOn Availability GroupsYes (up to 8 secondary replicas, including 2 synchronous secondary replicas)
Connection DirectorYes
Online page and file restoreYes
Online indexingYes
Online schema changeYes
Fast recoveryYes
Mirrored backupsYes
Hot Add Memory and CPU2Yes
Database Recovery AdvisorYesYesYesYesYesYesYes
Encrypted BackupYesYesYes
Smart BackupYesYesYesNo

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

2This feature is only available for 64-bit SQL Server.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Multi-instance support50505050505050
Table and index partitioningYes
Data compressionYes
Resource GovernorYes
Partition Table ParallelismYes
Multiple Filestream containersYes
NUMA Aware Large Page Memory and Buffer Array AllocationYes
Buffer Pool Extension 1YesYesYes
IO Resource GovernanceYes
In-Memory OLTP 1Yes
Delayed durabilityYesYesYesYesYesYesYes

1 This feature is only available for 64-bit SQL Server.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Basic AuditingYesYesYesYesYesYesYes
Fine Grained AuditingYes
Transparent database encryptionYes
Extensible Key ManagementYes
User-Defined RolesYesYesYesYesYesYesYes
Contained DatabasesYesYesYesYesYesYesYes
Encryption for BackupsYesYesYes
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server change trackingYesYesYesYesYesYesYes
Merge replicationYesYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Transactional replicationYesYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Snapshot replicationYesYesYesYes (Subscriber onlyYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Heterogeneous subscribersYesYesYes
Oracle publishingYes
Peer to Peer transactional replicationYes
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Management Objects (SMO)YesYesYesYesYesYesYes
SQL Configuration ManagerYesYesYesYesYesYesYes
SQL CMD (Command Prompt tool)YesYesYesYesYesYesYes
SQL Server Management StudioYesYesYesYesYesYes
Distributed Replay – Admin ToolYesYesYesYesYesYes
Distributed Replay - ClientYesNoYesYes
Distributed Replay - ControllerYes (Enterprise supports up to 16 clients, Developer supports only 1 client)NoYes (1 client support only)Yes (1 client support only)
SQL ProfilerYesYesYesNo2No2No2No2
SQL Server AgentYesYesYesYes
Microsoft System Center Operations Manager Management PackYesYesYesYes
Database Tuning Advisor (DTA)YesYesYes3Yes3
Deploy a SQL Server Database to a Windows Azure VM WizardYesYesYesYesYesYesYes
SQL Server Data Files in Windows AzureYesYesYesYesYesYesYes

2 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.

3 Tuning enabled only on Standard edition features.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
User InstancesYesYesYes
LocalDBYesYes
Dedicated admin connectionYesYesYesYesYes (under trace flag)Yes (under trace flag)Yes (under trace flag)
PowerShell scripting supportYesYesYesYesYesYesYes
SysPrep support1YesYesYesYesYesYesYes
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 a 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 view 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 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 DatabasesYesYesYesYesYesYesYes
Buffer Pool Extension2YesYesYes

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

2 This feature is only available for 64-bit SQL Server.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Microsoft Visual Studio IntegrationYesYesYesYesYesYesYes
Intellisense (Transact-SQL and MDX)YesYesYesYesYesYesYes
SQL Server Data Tools (SSDT)YesYesYesYesYes
SQL query edit and design tools1YesYesYes
Version control support1YesYesYes
MDX edit, debug, and design tools1YesYesYes

1 This feature is not available for 64-bit version of Standard edition.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
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)YesYesYesNo (Client only)No (Client only)No (Client only)No (Client only)
Transact-SQL endpointsYesYesYesYes
FeatureEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server Import and Export WizardYesYesYesYesYesYesYes
Built-in data source connectorsYesYesYesYesYesYesYes
SSIS designer and runtimeYesYesYes
Basic TransformsYesYesYes
Basic data profiling toolsYesYesYes
Change Data Capture Service for Oracle by AttunityYes
Change Data Capture Designer for Oracle by AttunityYes

Integration Services - Advanced Adapters

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
High performance Oracle destinationYes
High performance Teradata destinationYes
SAP BW source and destinationYes
Data mining model training destination adapterYes
Dimension processing destination adapterYes
Partition processing destination adapterYes
Change Data Capture components by AttunityYes
Connector for Open Database Connectivity (ODBC) by AttunityYes

Integration Services - Advanced Transforms

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Persistent (high performance) lookupsYes
Data mining query transformationYes
Fuzzy grouping and lookup transformationsYes
Term extractions and lookup transformationsYes
System_CAPS_ICON_note.jpg Note

  • Master Data Services is available on the 64-bit editions of Business Intelligence and Enterprise only.
FeatureEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Master Data Services databaseYesYes
Master Data Manager web applicationYesYes
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Create cubes without a databaseYesYesYes
Auto-generate staging and data warehouse schemaYesYesYes
Change data captureYes
Star join query optimizationsYes
Scalable read-only Analysis Services configurationYes
Parallel query processing on partitioned tables and indicesYes
xVelocity memory optimized columnstore indexesYes
Global Batch AggregationYes
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Scalable Shared Databases (Attach/Detach, Read only databases)YesYes
Backup/Restore, Attach/Detach databasesYesYesYes
Synchronize databasesYesYes
High AvailabilityYesYesYes
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL)YesYesYes

BI Semantic Model (Multidimensional)

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Semi-additive MeasuresYesYesNo1
HierarchiesYesYesYes
KPIsYesYesYes
PerspectivesYesYes
ActionsYesYesYes
Account intelligenceYesYesYes
Time IntelligenceYesYesYes
Custom rollupsYesYesYes
Writeback cubeYesYesYes
Writeback dimensionsYesYes
Writeback cellsYesYesYes
DrillthroughYesYesYes
Advanced hierarchy types (Parent-Child, Ragged Hiearchies)YesYesYes
Advanced dimensions (Reference dimensions, many-to-many dimensionsYesYesYes
Linked measures and dimensionsYesYes
TranslationsYesYesYes
AggregationsYesYesYes
Multiple PartitionsYesYesYes, up to 3
Proactive CachingYesYes
Custom Assemblies (stored procs)YesYesYes
MDX queries and scriptsYesYesYes
DAX queriesYesYes
Role-based security modelYesYesYes
Dimension and Cell-level SecurityYesYesYes
Scalable string storageYesYesYes
MOLAP, ROLAP, HOLAP storage modesYesYesYes
Binary and compressed XML transportYesYesYes
Push-mode processingYesYes
Direct WritebackYesYes
Measure ExpressionsYesYes

1The 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.

BI Semantic Model (Tabular)

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
HierarchiesYesYes
KPIsYesYes
PerspectivesYesYes
TranslationsYesYes
DAX calculations, DAX queries, MDX queriesYesYes
Row-level SecurityYesYes
PartitionsYesYes
In-Memory and DirectQuery storage modes (Tabular only)YesYes

PowerPivot for SharePoint

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SharePoint farm integration based on shared service architectureYesYes
Usage reportingYesYes
Health monitoring rulesYesYes
PowerPivot GalleryYesYes
PowerPivot Data RefreshYesYes
PowerPivot Data FeedsYesYes

Data Mining

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
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

Reporting Services Features

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Supported catalog DB SQL Server editionStandard or higherStandard or higherStandard or higherWebExpress
Supported data source SQL Server editionAll SQL Server editionsAll SQL Server editionsAll SQL Server editionsWebExpress
Report serverYesYesYesYesYes
Report DesignerYesYesYesYesYes
Report ManagerYesYesYesYesYes
Role based securityYesYesYesYesYes
Word Export and Rich Text SupportYesYesYesYesYes
Enhanced gauges and chartingYesYesYesYesYes
Export to Excel, PDF, and ImagesYesYesYesYesYes
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
Data driven report subscriptionYesYes
Scale out deployment (Web farms)YesYes
Alerting2YesYes
Power View 2YesYes

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

2Requires Reporting Services in SharePoint mode. For more information, see Reporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013).

Report Server Database Server Edition Requirements

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
EnterpriseStandard, Business Intelligence Enterprise, editions (local or remote)
Business IntelligenceStandard, Business Intelligence Enterprise, editions (local or remote)
StandardStandard, Enterprise 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 Downloads 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 is supported for 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.

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Report BuilderYesYesYes
Data Mining Addins for Excel and Visio 2010YesYesYes
PowerPivot for Excel 2010YesYes
Master Data Services Add-in for ExcelYesYes
System_CAPS_ICON_note.jpg Note

  1. PowerPivot for Excel is an Excel addin and does not depend on SQL Server. However PowerPivot for SharePoint is required for sharing and collaborating with PowerPivot workbooks in SharePoint and this capability is available as part of SQL Server Enterprise and Business Intelligence editions.
  2. The above table identifies the SQL Server editions that are required to enable these client tools; however these features can access data hosted on any edition of SQL Server.
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Spatial indexesYesYesYesYesYesYesYes
Planar and Geodetic datatypesYesYesYesYesYesYesYes
Advanced spatial librariesYesYesYesYesYesYesYes
Import/export of industry-standard spatial data formatsYesYesYesYesYesYesYes
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server Migration AssistantYesYesYesYesYesYesYes
Database mailYesYesYesYes
Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Data Quality ServicesYesYes
StreamInsightStreamInsight Premium EditionStreamInsight Standard EditionStreamInsight Standard EditionStreamInsight Standard Edition
StreamInsight HAStreamInsight Premium Edition

Product Specifications for SQL Server 2014
Installation for SQL Server 2014
Quick-Start Installation of SQL Server 2014

Show:
© 2016 Microsoft