SQL 2008 R2

November 22nd, 2009 by Stephen Jones Leave a reply »

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


Leave a Reply

You must be logged in to post a comment.