| Resource Limits |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| CPU Limit |
1 |
2 |
4 |
4 |
OS Max |
| RAM Limit |
1 GB |
OS Max |
OS Max1 |
OS Max |
OS Max |
| Database Size Limit |
4 GB |
Unlimited |
Unlimited |
Unlimited |
Unlimited |
| |
| Scalability |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Partitioning |
 |
|
|
|
 |
| Data Compression |
|
|
|
|
|
| Resource Governor |
|
|
|
|
|
| Partition Table Parallelism |
|
|
|
|
|
| |
| High Availability |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Multi-Instance Support |
16 |
16 |
16 |
16 |
50 |
| Online System Changes |
|
|
|
|
|
| Backup Log Shipping |
|
|
|
|
|
| Database Mirroring |
Witness
Only |
Witness
Only |
Witness
Only |
Safety Full Only |
Full
|
| Failover Clustering |
|
|
|
2 Nodes |
OS Max2 |
| Dynamic AWE |
|
|
|
|
|
| Failover Without Client Configuration |
|
|
|
|
|
| Automatic Corruption Recovery From Mirror |
|
|
|
|
|
| Database Snapshots |
|
|
|
|
|
| Fast Recovery |
|
|
|
|
|
| Online Indexing |
|
|
|
|
|
| Online Restore |
|
|
|
|
|
| Mirrored Backups |
|
|
|
|
|
| Hot Add Memory |
|
|
|
|
|
| Online Configuration of P2P Nodes |
|
|
|
|
|
| Hot Add CPU |
|
|
|
|
|
| Backup Compression |
|
|
|
|
|
| |
| Security |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| C2 Compliant Tracing |
|
|
|
|
|
| SQL Auditing Foundation |
|
|
|
|
|
| Fine Grained Auditing |
|
|
|
|
|
| Transparent Database Encryption |
|
|
|
|
|
| ISV Encryption (Off-box Key Management) |
|
|
|
|
|
| |
| Replication |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Merge Replication |
Subscriber Only |
Subscriber Only |
Subscriber Only |
|
|
| Transactional Replication |
Subscriber Only |
Subscriber Only |
Subscriber Only |
|
|
| Snapshot Replication |
Subscriber Only |
Subscriber Only |
Subscriber Only |
|
|
| SQL Server Change Tracking |
|
|
|
|
|
| Heterogeneous Subscribers |
|
|
|
|
|
| Oracle Publishing |
|
|
|
|
|
| P2P Transactional Replication |
|
|
|
|
|
| |
| Manageability |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| User Instances |
|
|
|
|
|
| Dedicated Admin Connection |
(Under Trace Flag) |
|
|
|
|
| Policy-Based Configuration |
|
|
|
|
|
| Policy-Based Management |
|
|
|
|
|
| Performance Data Collection and Warehouse |
|
|
|
|
|
| Standard Performance Reports |
|
|
|
|
|
| Plan Guides |
|
|
|
|
|
| Plan Freezing for Plan Guides |
|
|
|
|
|
| Policy-based Best Practices |
|
|
|
|
|
| Multi-Server Policy-based Management |
|
|
|
|
|
| Distributed Partition Views |
|
|
|
|
|
| Parallel Index Operations |
|
|
|
|
|
| Automatic Query-to-Indexed-View Matching |
|
|
|
|
|
| Parallel Database Backup Checksum Check |
|
|
|
|
|
| Database Mail |
|
|
|
|
|
| Database Migration Tools |
|
|
|
|
|
| |
| Management Tools |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| SQL Management Objects (SMO) |
|
|
|
|
|
| SQL Configuration Manager |
|
|
|
|
|
| SQL CMD (Command Prompt Tool) |
|
|
|
|
|
| SQL Server Management Studio |
3 |
4 |
|
|
|
| SQL Profiler |
|
|
|
|
|
| SQL Server Agent |
|
|
|
|
|
| Database Tuning Advisor |
|
|
|
|
|
| Microsoft Operations Manager Pack |
|
|
|
|
|
| |
| Development Tools |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Microsoft Visual Studio Integration |
|
|
|
|
|
| SQL Query and Edit and Design Tools |
|
|
|
|
|
| Intellisense (Transact-SQL and MDX) |
|
|
|
|
|
| Version control support |
|
|
|
|
|
| Business Intelligence Development Studio |
|
|
|
|
|
| MDX Edit, Debug, and Design Tools |
|
|
|
|
|
| |
| Programmability |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Common Language Runtime (CLR) Integration |
|
|
|
|
|
| Native XML Support |
|
|
|
|
|
| XML indexing |
|
|
|
|
|
| MERGE and UPSERT Capabilities |
|
|
|
|
|
| FILESTREAM Support |
|
|
|
|
|
| Date and Time Data Types |
|
|
|
|
|
| Internationalization Support |
|
|
|
|
|
| Full-Text Search |
|
|
|
|
|
| Specification of Language in Query |
|
|
|
|
|
| Service Broker (Messaging) |
Client Only |
Client Only |
|
|
|
| XML/A Support |
|
|
|
|
|
| Web Services (HTTP/SOAP Endpoints) |
|
|
|
|
|
| |
| Spatial and Location Services |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Spatial Indexes |
|
|
|
|
|
| Geodetic Data Type |
|
|
|
|
|
| Advanced Spatial Libraries |
|
|
|
|
|
| Standards-Based Spatial Support |
|
|
|
|
|
| |
| Integration Services |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| SQL Server Import and Export Wizard with basic sources and destinations and Execute SQL Task |
|
|
|
|
|
| Integration Services Runtime |
|
|
|
|
|
| Integration Services API and Object Model |
|
|
|
|
|
| SSIS Designer Including VSTA Scripting |
|
|
|
|
|
| Integration Services Service, Wizards, and Command Prompt Utilities |
|
|
|
|
|
| Basic Tasks and Transformations |
|
|
|
|
|
| Log Providers and Logging |
|
|
|
|
|
| Data Profiling Tools |
|
|
|
|
|
| Additional Sources and Destinations |
|
|
|
|
|
| Advanced Sources, Transformations, and Destinations |
|
|
|
|
|
| |
| Data Warehouse Creation |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Create Cubes Without a Database |
|
|
|
|
|
| Auto-Generate Staging and Data Warehouse Schema |
|
|
|
|
|
| Attribute Relationship Designer |
|
|
|
|
|
| Efficient Aggregation Designers |
|
|
|
|
|
| |
| Data Warehouse Scale and Performance |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Change Data Capture |
|
|
|
|
|
| Star Join Query Optimization |
|
|
|
|
|
| Scalable Read-Only AS Configuration |
|
|
|
|
|
| Proactive Caching |
|
|
|
|
|
| Auto Parallel Partition Processing |
|
|
|
|
|
| Partitioned Cubes |
|
|
|
|
|
| Distributed Partitioned Cubes |
|
|
|
|
|
| |
| Multi-Dimensional Analytics |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| SQL Server Analysis Services Service |
|
|
|
|
|
| SQL Server Analysis Services Backup |
|
|
|
|
|
| General Performance/Scale Improvements |
|
|
|
|
|
| Dimension, Attribute Relationship, Aggregate, and Cube Design Improvements |
|
|
|
|
|
| Personalization Extensions |
|
|
|
|
|
| Financial Aggregations |
|
|
|
|
|
| Partitioned Customers |
|
|
|
|
|
| Custom Rollups |
|
|
|
|
|
| Semi-Additive Measures |
|
|
|
|
|
| Writeback Dimensions |
|
|
|
|
|
| Linked Measures and Dimensions |
|
|
|
|
|
| Binary and Compressed XML Transport |
|
|
|
|
|
| Account Intelligence |
|
|
|
|
|
| Perspectives |
|
|
|
|
|
| Analysis Services Shared, Scalable Databases |
|
|
|
|
|
| |
| Data Mining |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Standard Algorithms |
|
|
|
|
|
| Data Mining Tools: Wizards, Editors, Query Builders |
|
|
|
|
|
| Cross Validation |
|
|
|
|
|
| Models on Filtered Subsets of Mining Structure Data |
|
|
|
|
|
| Time Series: Custom Blending Between ARTXP and ARIMA Models |
|
|
|
|
|
| Time Series: Prediction With New Data |
|
|
|
|
|
| Unlimited Concurrent Datamining Queries |
|
|
|
|
|
| Advanced Configuration and Tuning for Algorithms |
|
|
|
|
|
| Algorithm Plug-In API |
|
|
|
|
|
| Parallel Model Processing |
|
|
|
|
|
| Time Series: Cross-Series Prediction |
|
|
|
|
|
| Unlimited Attributes for Association Rules |
|
|
|
|
|
| Sequence Prediction |
|
|
|
|
|
| Multiple Prediction Targets for Naive Bayes, Neural Network, and Logistic Regression |
|
|
|
|
|
| |
| Reporting |
Express |
Web |
Workgroup |
Standard |
Enterprise |
| Report Server |
|
|
|
|
|
| Report Designer |
|
|
|
|
|
| Report Manager |
|
Report Manager |
|
|
|
| Role-Based Security |
|
Fixed Roles |
Fixed Roles |
|
|
| Ad-Hoc Reporting (Report Builder) |
|
|
|
|
|
| Word Export and Enhanced Text Formatting |
|
|
|
|
|
| Enterprise-Scale Reporting Engine |
|
|
|
|
|
| IIS-Agnostic Report Deployment |
|
|
|
|
|
| Updated Management Tools |
|
|
|
|
|
| Report Definition Customization Extension (RDCE) |
|
|
|
|
|
| SharePoint Integration |
|
|
|
|
|
| Enhanced SSRS Gauges and Charting |
|
|
|
|
|
| Custom Authentication |
|
|
|
|
|
| Export to Excel, PDF, and Images |
|
|
|
|
|
| Remote and Non-Relational Data Source Support |
|
|
|
|
|
| E-mail and File Share Delivery |
|
|
|
|
|
| Report History, Scheduling, Subscriptions, and Caching |
|
|
|
|
|
| Data Source, Delivery, and Rendering Extensibility |
|
|
|
|
|
| Scale Out (Web Farms) |
|
|
|
|
|
| Infinite Click-Through |
|
|
|
|
|
| Data-Driven Subscriptions |
|
|
|
|
|
| Reporting Services Memory Limits |
|
4 GB |
4 GB |
Unlimited |
Unlimited |