|
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
|