Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday, 12 June 2017

Comparison / Explanation of features Between Enterprise and Standard and Express in SQL Server

Comparison/ Explanation of features Enterprise and Standard and Express in SQL Server

Ref:
https://technet.microsoft.com/en-us/library/cc645993(v=sql.110).aspx


Feature Name
Enterprise
Business Intelligence

Standard
Web
Express with Advanced Services
Express with Tools
Express
Server Core support1
Yes
Yes

Yes
Yes
Yes
Yes
Yes
Log Shipping
Yes
Yes

Yes
Yes
Database mirroring
Yes
Yes (Safety Full Only)

Yes (Safety Full Only) Synchronous only
Witness only
Witness only
Witness only
Witness only
AlwaysOn Failover Cluster Instances
Yes (Node support: Operating system maximum
Yes (Node support: 2)

Yes (Node support: 2)
Backup compression
Yes
Yes

Yes
Database snapshot
Yes

AlwaysOn Availability Groups
Yes

Connection Director
Yes

Online page and file restore
Yes

Online indexing
Yes

Online schema change
Yes

Fast recovery
Yes

Mirrored backups
Yes



Feature Name
Enterprise
Business Intelligence
Standard
Web
Express with Advanced Services
Express with Tools
Express
Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1
Operating System maximum
Limited to lesser of 4 Sockets or 16 cores
Limited to lesser of 4 Sockets or 16 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
Limited to lesser of 1 Socket or 4 cores
Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1
Operating system maximum
Operating system maximum
Limited to lesser of 4 Sockets or 16 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
Limited to lesser of 1 Socket or 4 cores
Maximum memory utilized (per instance of SQL Server Database Engine)
Operating system maximum
64 GB
64 GB
64 GB
1 GB
1 GB
1 GB
Maximum memory utilized (per instance of Analysis Services)
Operating system maximum
Operating system maximum
64 GB
N/A
N/A
N/A
N/A
Maximum memory utilized (per instance of Reporting Services)
Operating system maximum
Operating system maximum
64 GB
64 GB
4 GB
N/A
N/A
Maximum relational Database size
524 PB
524 PB
524 PB
524 PB
10 GB
10 GB
10 GB




Feature Name
Enterprise
Business Intelligence
Standard
Web
Express with Advanced Services
Express with Tools
Express
Multi-instance support
50
50
50
50
50
50
50
Table and index partitioning
Yes
Data compression
Yes
Resource Governor
Yes
Partition Table Parallelism
Yes
Multiple Filestream containers
Yes

Feature Name
Enterprise
Business Intelligence
Standard
Web
Express with Advanced Services
Express with Tools
Express
SQL Server change tracking
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Merge replication
Yes
Yes
Yes
Yes (Subscriber only)
Yes (Subscriber only)
Yes (Subscriber only)
Yes (Subscriber only)
Transactional replication
Yes
Yes
Yes
Yes (Subscriber only)
Yes (Subscriber only)
Yes (Subscriber only)
Yes (Subscriber only)
Snapshot replication
Yes
Yes
Yes
Yes (Subscriber only
Yes (Subscriber only)
Yes (Subscriber only)
Yes (Subscriber only)
Heterogeneous subscribers
Yes
Yes
Yes
Oracle publishing
Yes
Peer to Peer transactional replication