Sql_server_2008版本功能及参数比较.docx

Sql server 2008版本功能及参数比较Scalability可扩展性功能名称EnterpriseStandardWorkgroupWebExpressExpress Tools Express AdvancedPartitioning分区YesData compression数据压缩YesResource governor资源总揽YesPartition table parallelism分区表并行Yes?High Availability高可用性功能名称EnterpriseStandardWorkgroupWebExpressExpress ToolsExpress AdvancedMulti-instance support 多实例支持50161616161616Online system changes 在线系统的变化YesYesYesYesYesYesYesBackup log shipping 备份日志传送YesYesYesYesDatabase mirroring2 数据库镜像Yes (full)Yes (safety full only)Witness onlyWitness onlyWitness onlyWitness onlyWitness onlyFailover clustering 故障转移群集Operating system maximum12 nodes(节点)Dynamic AWE 动态扩展YesYesFailover without client configuration 容错YesYesAutomatic corruption recovery from mirror 失败自动恢复镜像YesYesDatabase snapshots 数据库快照YesFast recovery 快速恢复YesOnline indexing 在线索引YesOnline restore 在线恢复YesMirrored backups镜像备份YesHot add memory 热内存添加YesOnline configuration of P2P nodes 在线点对点配置YesHot add CPU 热添加CPUYesBackup compression 备份压缩Yes1 Windows Server 2003中支持最多8故障转移群集节点。 Windows Server 2008的支持的和最多16故障转移群集节点。Security安全性功能名称EnterpriseStandardWorkgroupWebExpressExpress ToolsExpress AdvancedC2 audit mode C2审计模式YesYesYesYesYesYesYesSQL Server auditing SQL Server审计YesTransparent database encryption 透明的数据库加密YesISV encryption (off-box key management) 独立软件开发商的加密（非官方密钥管理）YesReplication复制功能名称EnterpriseStandardWorkgroupWebExpressExpress ToolsExpress AdvancedMerge replication合并复制YesYesSubscriber only1Subscriber onlySubscriber onlySubscriber onlySubscriber onlyTransactional replication 交易复制YesYesSubscriber only1Subscriber onlySubscriber onlySubscriber onlySubscriber onlySnapshot replication 快照复制YesYesSubscriber onlySubscriber onlySubscriber onlySubscriber onlySubscriber onlySQL Server change tracking SQL Server变化跟踪YesYesYesYesYesYesYesHeterogeneous subscribers异构用户YesYesOracle publishing甲骨文PublishingYesP2P transactional replication P2P网络复制Yes1If an instance of WorkGroup is used as a Publisher, it supports a maximum of 25 subscriptions to all merge publications, and