Sqlserver2008版本功能及参数比较

Sql server 2008 版本功能及 比较 参数
Scalability
可较展性
功能名称 Enterprise Standard Workgroup Web Express Express Tools Express Advanced
Partitioning 分区
Yes
Data compression 据较较 数
Yes
Resource governor
较源较较
Yes
Partition table parallelism
分 表 行 区 并
Yes

High Availability
高可用性
功能名称 Enterprise Standard Workgroup Web Express
Express
Tools
Express
Advanced
Multi-instance support 多较例支持
50 16 16 16 16 16 16
Online system changes 在较系较的较
化
Yes Yes Yes Yes Yes Yes Yes
Backup log shipping 较 日志较送 份
Yes Yes Yes Yes
Database mirroring2 据较较像 数
Yes (full) Yes (safety full
only)
Witness only Witness
only
Witness
only
Witness
only
Witness only
Failover clustering 故障较移群集
Operating system
maximum1
2 nodes
Dynamic AWE 较较较展
Yes Yes
Failover without client configuration
容较
Yes Yes
Automatic corruption recovery from
mirror 失较自较恢较较像
Yes Yes
Database snapshots 据较快照 数
Yes
Fast recovery 快速恢较
Yes
Online indexing 在较索引
Yes
Online restore 在较恢较
Yes
Mirrored backups
较像较份
Yes
Hot add memory 较 存添加 内
Yes
Online configuration of P2P nodes
在较点较点配置
Yes
Hot add CPU 较添加CPU
Yes
Backup compression 较 较较 份
Yes
1 Windows Server 2003 中支持最多8 故障较移群集较点。 Windows Server 2008 的支持的和最多16 故障较移群集较点。
http://wendang.chazidian.com
Security
安全性
功能名称 Enterprise Standard Workgroup Web Express
Express
Tools
Express
Advanced
C2 audit mode C2 较较模式
Yes Yes Yes Yes Yes Yes Yes
SQL Server auditing SQL Server 较较
Yes
Transparent database encryption 透明的 据较加密 数
Yes
ISV encryption (off-box key management) 立较件较较商 独
的加密（非官方密较管理）
Yes
Replication
较制
功能名称 Enterprise Standard Workgroup Web Express
Express
Tools
Express
Advanced
Merge replication 合 较制 并
Yes Yes Subscriber
only?
Subscriber
only
Subscriber
only
Subscriber
only
Subscriber only
Transactional replication 交易较制
Yes Yes Subscriber
only?
Subscriber
only
Subscriber
only
Subscriber
only
Subscriber only
Snapshot replication 快照较制
Yes Yes Subscriber
only
Subscriber
only
Subscriber
only
Subscriber
only
Subscriber only
SQL Server change tracking SQL
Server 较化 踪 跟
Yes Yes Yes Yes Yes Yes Yes
Heterogeneous subscribers 用较 异构
Yes Yes
Oracle publishing 甲骨文Publishing
Yes
P2P transactional replication P2P 网
较较制
Yes
?If an instance of WorkGroup is used as a Publisher, it supports a maximum of 25 subscriptions to all merge publications, and five subscriptions
to all transactional publications. It supports an unlimited number of subscriptions to snapshot publications.
Reporting
Feature Name Enterprise Standard Workgroup Web Express
Express
Tools
Express
Advanced
Report server Yes Yes Yes Yes Yes
Report Designer Yes Yes Yes Yes Yes
Report Manager Yes Yes Yes Yes (Report
Manager)
Yes (Report
Manager)
Role-based security Yes Yes Yes (Fixed
roles)
Yes (Fixed roles) Yes (Fixed roles)
Ad-hoc reporting (Report builder) Yes Yes Yes
Word export and enhanced text
formatting
Yes Yes Yes Yes Yes
Enterprise-scale reporting engine Yes Yes Yes Yes Yes
IIS-agnostic report deployment Yes Yes Yes Yes Yes
Updated management tools Yes Yes Yes Yes Yes
Report definition customization
extension (RDCE)
Yes Yes Yes Yes Yes
SharePoint integration Yes Yes
Enhanced SSRS gauges and
charting
Yes Yes Yes Yes Yes
Custom authentication Yes Yes Yes Yes
Export to Excel, PDF, and images Yes Yes Yes Yes Yes
Remote and non-relational data
source support
Yes Yes
E-mail and file share delivery Yes Yes
Report history, scheduling,
subscriptions, and caching
Yes Yes
Data source, deliver y, and rendering
extensibility
Yes Yes
Scale out (Web farms) Yes
Infinite clickthrough Yes
Data-driven subscriptions Yes
Reporting Services memory limits OS
Maximum
OS
Maximum
4 GB 4 GB 4 GB
http://wendang.chazidian.com