SQL Server 2008 New Editions

Leave a comment (1) Go to comments

Microsoft has come with two new editions  named “SQL Server 2008 R2 Datacenter” and “SQL Server 2008 R2 Parallel Data Warehouse” in SQL Server R2 release. SQL Server 2008 is already have the following editions

Enterprise – For large-scale, business-critical applications

Standard – For small to medium departmental applications

Workgroup – For small-scale branch applications

Web – For low-cost, large-scale Web applications

Express – For entry-level and learning applications (Free)

Compact – For embedded databases (Free)

Developer – For development and testing (50$)


Following editions are newly added in SQL Server R2 release.

New Premium Editions in SQL Server R2 release


Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing 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 enable organizations to cost effectively scale their mission-critical environment.

Key features new to Datacenter:

· Application and Multi-Server Management for enrolling, gaining insights and managing over 25 instances

· Highest virtualization support for maximum ROI on consolidation and virtualization

· High-scale complex event processing with SQL Server StreamInsight™

· Supports more than 8 processors and up to 256 logical processors for highest levels of scale

· Supports memory limits up to OS maximum

Parallel Data Warehouse

SQL Server 2008 R2 Parallel Data Warehouse is 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



SQL Server 2008 R2 Datacenter Edition now supports systems with up to 64 physical processors and 256 cores. This support enables greater scalability in the x64 line than ever before. SQL Server 2008 R2 Enterprise Edition supports up to 64 processors, and Standard Edition supports up to four processors.

EOF - SQL Server 2008 New Editions, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment


  1. Datacenter Edition will allow the unlimited instance rights

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.