MS SQL Server 2012 - DBA Articles

Comparing the SQL Server 2012 Express, Web, and Standard Editions



The following table describes comparison of SQL Server Express, Web and Standard Editions.

Feature SQL Server 2012 Express SQL Server 2012 Web SQL Server 2012 Standard
Maximum number of instances 50 50 50
Maximum number of processors Lesser of 1 socket or 4 cores Lesser of 4 sockets or 16 cores Lesser of 4 sockets or 16 cores
Maximum RAM 1 GB 64 GB 64 GB
Maximum database size 10 GB 524 TB 524 TB
High Availability - log shipping No Yes Yes
High Availability - database mirroring Witness only Witness only Yes (Safety Full only)
High Availability - failover clustering No No Yes (2 nodes)
Backup compression No No Yes
Replication publishing No No Yes
SQL Server Agent No Yes Yes
Database Tuning Advisor No Yes Yes
BI Features (Analysis Services, Integration Services) No No Yes
Report Server Express with Advanced Services only Yes Yes
Supported Report Server catalog DB Express Web Standard or higher
Supported Report data source Express Web All editions
Service Broker Client-only Client-only Yes
Full-text semantic search Express with Advanced Services only Yes Yes
SQL Profiler No No Yes
Database Mail No Yes Yes
StreamInsight No Yes Yes


More Reference URL: http://msdn.microsoft.com/en-us/library/dn144931.aspx

* * * * *


Email Your Comment To AUTHOR