MS SQL Server2014标准版、企业版、易捷版对比.docx

MS SQL Server 2014各版本功能对比 可扩展性 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 128 GB 128 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 1?Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. There are no limits under the Core-based Server Licensing model. For more information, see?Compute Capacity Limits by Edition of SQL Server. ?Top 高可用性 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 Backup compression Yes Y