Compare SQL SE vs EE
Q1: What are the differences in Scalability and Performance between SQL SE and EE?
Q2: What are the differences in High Availability (Always On) features between SQL SE and EE?
Q3: What are the differences in Virtualization Support features between SQL SE and EE?
Q4: What are the differences in Replication features between SQL SE and EE?
Q5: What are the differences in Enterprise Security features between SQL SE and EE?
Q6: What are the differences in Application and Multi-Instance Management features between SQL SE and EE?
Q7: What are the differences in Management Tools features between SQL SE and EE?
Q8: What are the differences in Integration Services - Advanced Adapters features between SQL SE and EE?
Q9: What are the differences in Data Warehouse features between SQL SE and EE?
Q10: What are the differences in Analysis Services features between SQL SE and EE?
Q11: What are the differences in Analysis Services - Advanced Analytic Function features between SQL SE and EE?
Q12: What are the differences in Data Mining features between SQL SE and EE?
Q13: What are the differences in Reporting features between SQL SE and EE?
Q14: What are the differences in Business Intelligence Client features between SQL SE and EE?
Q15: What are the differences in Master Data Services features between SQL SE and EE?
Number of CPUs: SE = 4, EE = 8
Maximum memory utilized: SE = 64GB, EE = 2TB
Maximum Database size: SE and EE both support 524PB
The following 9 Scalability and Performance features are available in SQL Enterprise Edition (EE) and NOT available in Standard Edition (SE):
1) IA64 hardware support
2) Resource governor
3) Table and index partitioning
4) Parallel index operations
5) Parallel consistency checks (DBCC)
6) Enhanced read-ahead scan
7) Scalable shared databases
8) Indexed views
9) Distributed Partition Views
Database Mirroring: Fully supported in EE. Single thread and Synchronous ONLY in SE.
Number of Failover Clustering Nodes: EE = OS Maximum (Windows Server 2008 supports a maximum of 16 failover cluster nodes), SE = 2 Nodes
Backup Compression: Yes for both SE and EE, however, Backup Compression for SE is supported only in SQL Server 2008 R2 or higher versions.
The following 7 High Availability features are available in SQL Enterprise Edition (EE) and NOT available in Standard Edition (SE).
1) Mirrored backups
2) Database snapshots
3) Fast recovery
4) Online indexing
5) Online page and file restore
6) Online configuration of Peer to Peer nodes
7) Hot add memory and CPU support
The following 3 Virtualization features are supported by BOTH SE and EE.
1) Hypervisor Support
2) Guest failover clustering support for virtualization
3) Hyper-V live migration
The following Virtualization feature is available in EE and NOT in SE.
Application mobility
The following 5 Replication features are supported by BOTH SE and EE.
1) Snapshot replication
2) Merge replication
3) Transactional replication
4) SQL Server change tracking
5) Publishing data from SQL Server to non SQL Server subscribers
The following 2 Replication features are available in EE and NOT in SE.
1) Publishing data from Oracle to SQL Server
2) Peer to Peer replication
The following 3 Enterprise Security features are available in EE and NOT in SE.
1) SQL Server audit (fine-grained auditing)
2) Transparent database encryption
3) Extensible key management
The following Application and Multi-Instance Management feature is available in BOTH EE and SE.
1) Able to enroll for Multi-Instance Management
The following 2 Application and Multi-Instance Management features are available in EE and NOT in SE.
1) Multi-instance dashboard views and drilldowns
2) Policy-based resource utilization evaluation
The following Management Tools feature is available in EE and NOT in SE.
Analysis Services, PowerPivot IT operation dashboard
The following 5 Integration Services - Advanced Adapters features are available in EE and NOT in SE.
1) High performance Oracle destination
2) High performance Teradata destination
3) SAP BW source and destination
4) Data mining model training destination adapter
5) Dimension processing destination adapter
6) Partition processing destination adapter
The following Data Warehouse feature is available in BOTH EE and SE.
Auto-generate staging and data warehouse schema
The following 9 Data Warehouse features are available in EE and NOT in SE.
1) Change data capture
2) Data compression
3) Star join query optimization
4) Automatic query-to-indexed-view matching
5) Scalable read-only AS configuration
6) Proactive caching
7) Parallel query processing on partitioned tables and indices
8) Partitioned cubes
9) Distributed partitioned cubes
The following Analysis Services feature is available in EE and NOT in SE.
SQL Server PowerPivot for SharePoint
The following 10 Analysis Services - Advanced Analytic Function features are available in EE and NOT in SE.
1) Financial aggregations
2) Partitioned cubes and distributed partitioned cubes
3) Custom rollups
4) Semi-additive measures
5) Writeback dimensions
6) Linked measures and dimensions
7) Binary and compressed XML transport
8) Account intelligence
9) Perspectives
10) Scalable shared databases
The following 2 Data Mining features are available in BOTH EE and SE.
1) Comprehensive set of data mining algorithms
Integrated data mining tools: wizards, editors, model viewers, query builder
The following 6 Data Mining features are available in EE and NOT in SE.
1) Cross validation
2) Advanced configuration and tuning options for data mining algorithms
3) Support for pipeline data mining and text mining with Integration Services
4) Support for plug-in algorithms
5) Parallel model processing
6) Sequence prediction
The following 2 Reporting features are available in EE and NOT in SE.
1) Data-driven report subscriptions
2) Scale out deployment (Web farms)
The following Business Intelligence Client features are available in EE and NOT in SE.
PowerPivot for Excel
The following 3 Master Data Services features are available in EE and NOT in SE.
1) Master Data Services database
2) Master Data Manager Web application
3) Master Data Services Web service