《MS SQL Server2014标准版、企业版、易捷版对比》由会员分享，可在线阅读，更多相关《MS SQL Server2014标准版、企业版、易捷版对比（26页珍藏版）》请在金锄头文库上搜索。
1、MS SQL Server 2014 各版本功能对比可扩展性Feature Name Enterprise Business Intelligence Standard WebExpress with Advanced ServicesExpress with Tools ExpressMaximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1Operating System maximumLimited to lesser of 4 Sockets or 16 coresLimited to
2、 lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresMaximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1Operating syst
3、em maximumOperating system maximumLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 4 Sockets or 16 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresLimited to lesser of 1 Socket or 4 coresMaximum memory utilized (per instance of SQL Server Database E
4、ngine)Operating system maximum128 GB 128 GB 64 GB 1 GB 1 GB 1 GBMaximum memory utilized (per instance of Analysis Services)Operating system maximumOperating system maximum64 GB N/A N/A N/A N/AMaximum memory utilized (per instance of Reporting Services)Operating system maximumOperating system maximum
5、64 GB 64 GB 4 GB N/A N/AMaximum relational Database size524 PB 524 PB 524 PB 524 PB 10 GB 10 GB 10 GB1 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 unde
6、r 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 WebExpress with Advanced ServicesExpress with ToolsExpressServer Core support1Yes Yes Yes Yes Yes Yes YesLog Shipping Yes
7、Yes Yes YesDatabase mirroringYes Yes (Safety Full Only)Yes (Safety Full Only)Witness onlyWitness only Witness onlyWitness onlyBackup compressionYes Yes YesDatabase snapshot YesAlwayson Failover Cluster InstancesYes (Node support: Operating system maximumYes (Node support: 2)Yes (Node support: 2)Alwa
8、ysOn Availability GroupsYes (up to 8 secondary replicas, including 2 synchronous secondary replicas)Connection DirectorYesOnline page and file restoreYesOnline indexing YesOnline schema changeYesFast recovery YesMirrored backups YesHot Add Memory and CPU2YesDatabase Recovery AdvisorYes Yes Yes Yes Y
9、es Yes YesEncrypted Backup Yes Yes YesSmart Backup Yes Yes Yes No1For more information on installing SQL Server 2014 on Server Core, see Install SQL Server 2014 on Server Core.2This feature is only available for 64-bit SQL Server.Top容量和性能Feature Name Enterprise Business Intelligence Standard Web Exp
10、ress with Advanced Services Express with Tools ExpressMulti-instance support 50 50 50 50 50 50 50Table and index partitioning YesData compression YesResource Governor YesPartition Table Parallelism YesMultiple Filestream containers YesNUMA Aware Large Page Memory and Buffer Array AllocationYesBuffer
11、 Pool Extension 1 Yes Yes YesIO Resource Governance YesIn-Memory OLTP 1 YesDelayed durability Yes Yes Yes Yes Yes Yes Yes1 This feature is only available for 64-bit SQL Server.Top安全性Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools ExpressBa
12、sic Auditing Yes Yes Yes Yes Yes Yes YesFine Grained Auditing YesTransparent database encryptionYesExtensible Key Management YesUser-Defined Roles Yes Yes Yes Yes Yes Yes YesContained Databases Yes Yes Yes Yes Yes Yes YesEncryption for Backups Yes Yes YesTop复制Feature Name Enterprise Business Intelli
13、gence Standard WebExpress with Advanced ServicesExpress with Tools ExpressSQL Server change trackingYes Yes Yes Yes Yes Yes YesMerge replication Yes Yes Yes Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Transactional replicationYes Yes Yes Yes (Subscriber only)Y
14、es (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Snapshot replicationYes Yes Yes Yes (Subscriber onlyYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Heterogeneous subscribersYes Yes YesOracle publishing YesPeer to Peer transactional replicationYesTop管理工具Feature Name Enter
15、prise Business Intelligence Standard WebExpress with Advanced ServicesExpress with ToolsExpressSQL Management Objects (SMO)Yes Yes Yes Yes Yes Yes YesSQL Configuration ManagerYes Yes Yes Yes Yes Yes YesSQL CMD (Command Prompt tool)Yes Yes Yes Yes Yes Yes YesSQL Server Management StudioYes Yes Yes Ye
16、s Yes YesDistributed Replay Admin ToolYes Yes Yes Yes Yes YesDistributed Replay - ClientYes No Yes YesDistributed Replay - ControllerYes (Enterprise supports up to 16 clients, Developer supports only 1 client)No Yes (1 client support only)Yes (1 client support only)SQL Profiler Yes Yes Yes No2 No2 No2 No2SQL Server Agent Yes Yes Yes YesMicrosoft System Center Operations Manager Management PackYes Yes Yes YesDatabase Tuning Advisor (DTA)Yes Yes Yes3 Yes3Deploy a SQ
