:::: MENU ::::

SQL Server 2012 Edition comparisons

 

First off, MS really should have upped the max memory cap beyond 64GB on Standard Edition, RAM is so cheap now that we’re seeing more and more servers with > 132 GB memory. Sadly, they have not.

Information is from page http://msdn.microsoft.com/en-us/library/cc645993.aspx I just needed it a bit compressed and from a DBA perspective.

 

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 (SQL Server Database Engine) Operating system maximum 64 GB 64 GB 64 GB 1 GB 1 GB 1 GB
Maximum memory utilized (Analysis Services) Operating system maximum Operating system maximum 64 GB N/A N/A N/A N/A
Maximum memory utilized (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
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) Witness only Witness only Witness only Witness only
Failover Clustering 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
SQL Server Multi-Subnet Clustering Yes
Connection Director Yes
Online page and file restore Yes
Online indexing Yes
Online schema change Yes
Fast recovery Yes
Mirrored backups Yes
Hot Add Memory and CPU2 Yes
Database Recovery Advisor Yes Yes Yes Yes Yes Yes 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 Yes

 

Report Server Database Server Edition Requirements

When creating a report server database, not all editions of SQL Server can be used to host the database. The following table shows you which editions of the Database Engine you can use for specific editions of Reporting Services.

For this edition of SQL Server Reporting Services Use this edition of the Database Engine instance to host the database
Enterprise Standard, Business Intelligence Enterprise, editions (local or remote)
Business Intelligence Standard, Business Intelligence Enterprise, editions (local or remote)
Standard Standard, Enterprise editions (local or remote)
Web Web edition (local only)
Express with Advanced Services Express with Advanced Services (local only).
Evaluation Evaluation

 

 

Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server Migration Assistant Yes Yes Yes Yes Yes Yes Yes
Database mail Yes Yes Yes Yes

 

 

 

 

 


So, what do you think ?