SQL Server 2008 Enterprise Edition
Comprehensive Data Solution for the
Enterprise
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
High Availability
Ensure business continuity with technologies that protect your
data against costly human errors, and minimize disaster-recovery
downtime.
Performance and Scalability
Deliver an infrastructure that has a proven record in handling
large amounts of data and critical enterprise workloads.
Security
Address privacy and compliance requirements and built-in features
that protect your data against unauthorized access.
Manageability
Manage your infrastructure with automated diagnostics, tuning, and
configuration to reduce operational costs while reducing
maintenance and managing very large amounts of data.
Business Intelligence
Easily query and analyze large amounts of data in your data
warehouse and data marts to transform it into business insight.
Key Usage Scenarios
Run business-critical data management applications with
enterprise-class scalability, high availability, and
security.
Manage online transaction processing (OLTP) on a very large
scale.
Perform advanced analytics on large amounts of data in data
warehouses.
Create reports on the analysis of large amounts of data.
SQL Server 2008 Enterprise Edition
Features
- 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
- Employ enterprise-wide encryption solutions with Extensible Key
Management and Hardware Security Modules
- Encrypt data without modifying applications, using Transparent
Data Encryption
- Audit all actions with the new Audit object
- Store data more effectively and reduce storage requirements for
your data using data compression
- Use star join query optimizations reduce query response time by
recognizing data warehouse join patterns
- Integrate the latest information into the data warehouse using
change data capture
- Build high-performance analysis solutions to reach virtually
any number of users with scalability and performance enhancements
in SQL Server Analysis Services
- Advanced Data Mining algorithms
- Take advantage of on-demand processing and better performance
with the re-engineered reporting engine for SQL Server Reporting
Services
- Increase extract, transform, and load (ETL) performance in SQL
Server Integration Services with scalable lookup tasks
