DaveWentzel.com            All Things Data

Edition Differences

 

Editions
Quick breakdown of the differences between the Editions of SQL Server 2008
 
Edition
Hardware Maximums
Other Features
 
Enterprise Edition
64 CPUs, 2TB RAM
has all features enabled including:  data compression, transparent db encryption, unlimited virtual machine licensing
 
Developer
same as EE
same as EE
 
Web Edition
4 CPUs, 2TB RAM
licensed per processor per month.  SSRS only. 
 
Standard
4 CPUs, 2TB RAM
SSAS, SSIS, SSRS
 
Workgroup
2 CPUs, 4GB RAM
SSRS only
 
Express 1 CPU, 1GB RAM 4 GB db size maximum.  Advanced includes SSRS.   
 
 
Features Only in Enterprise Edition
  • Hot add CPU
  • Hot add RAM
  • 50 named instances instead of 16
  • data compression
  • TDE
  • resource governor
  • paritioning
  • partition table parallelism
  • asynchronous mirroring mode (standard supports synchronous mirroring mode)
  • 16 failover cluster nodes vs 2 nodes in standard
  • database snapshots
  • fast recovery
  • online indexing
  • online restore
  • distributed partitioned views (for scaleout clusters)
  • filtered indexes (selectively index column values)
  • Oracle as a replication publisher
  • P2P transactional replication
  • SSIS advanced transformations (fuzzy lookup and data mining
  • change data capture (useful in data warehousing)
 
 

Add new comment