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
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
|
No comments:
Post a Comment