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

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Contact Me
R.K.Prem Nath
Madurai District
Tamil Nadu, India

[email protected]
[email protected]
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © . Data-e-Education. All Rights Reserved.