SQL Server 2008 R2 introduces two new premium editions to meet the needs of large scale datacenters and data warehouses.
• SQL Server 2008 R2 Datacenter •
SQL Server 2008 R2 Parallel Data Warehouse
Datacenter is designed to deliver a data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization’s database infrastructure.
Datacenter helps to cost effectively scale mission-critical environments. Key features new to Datacenter:
• Application and Multi-Server Management for enrolling, gaining insights and managing over 25 instances
• Highest virtualization support
• High-scale complex event processing with SQL Server StreamInsight
• Supports more than 8 processors and up to 256 logical processors
• Supports memory limits up to OS maximum
Parallel Data Warehouse a highly scalable data warehouse appliance-based solution. Parallel Data Warehouse delivers performance at low cost through a massively parallel processing (MPP) architecture and compatibility with hardware partners – scale your data warehouse to tens and hundreds of terabytes.
Key features new to Parallel Data Warehouse: •
10s to 100s TBs enabled by MPP architecture
• Advanced data warehousing capabilities like Star Join Queries and Change Data Capture
• Integration with SSIS, SSRS, and SSAS • Supports industry standard data warehousing hub and spoke architecture and parallel database copy S
The following capabilities are new to Enterprise:
• PowerPivot for SharePoint to support the hosting and management of PowerPivot applications in SharePoint •
Application and Multi-Server Management for enrolling, gaining insights and managing up to 25 instances
• Master Data Services for data consistency across heterogeneous systems
• Data Compression now enabled with UCS-2 Unicode support
The following capabilities are new to Standard
• Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups
• Can be managed instance for Application and Multi-Server Management capabilities