- Unlimited Virtualization
- Data and Backup Compression
- Resource Governor
- Transparent Data Encryption
- Extensible Key Management
SQL Server 2008 Enterprise Edition is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, advanced analytics, and security for running business-critical applications. With this edition, you can consolidate servers and perform large-scale online transactional processing and reporting.
- Manage large, growing tables more effectively by transparently breaking them into manageable blocks of data with partitioned table parallelism.
- Take advantage of failover clustering enhancements in Windows Server 2008.
- Recover corrupt data pages from a mirror server with enhanced database mirroring features.
- Use online operations to add new nodes to a peer-to-peer replication solution without taking replication offline.
- Use Resource Governor to proactively control workload prioritization and resource allocation.
Improve restore times, and reduce backup volumes with new support for backup compression. Reduce downtime for hardware maintenance with hot-add CPU capabilities. Use Performance Data Collector to troubleshoot, tune, and monitor SQL Server 2008 instances across the enterprise.