Monthly Archives: August 2013

SQL Server 2012 Features By Edition

The BI edition is the same as enterprise for the AS and RS resources.

http://msdn.microsoft.com/en-us/library/cc645993.aspx


Cross-Box Scale Limits


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 (per instance of SQL Server Database Engine) Operating system maximum 64 GB 64 GB 64 GB 1 GB 1 GB 1 GB
Maximum memory utilized (per instance of Analysis Services) Operating system maximum Operating system maximum 64 GB N/A N/A N/A N/A
Maximum memory utilized (per instance of 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

1Enterprise Edition with Server + Client Access License (CAL) based licensing is limited to a maximum of 20 cores per SQL Server instance. For more information, see Compute Capacity Limits by Edition of SQL Server.