United States   Change   |   All Microsoft Sites

Home - SQL Server 2005

Compare Enterprise and Standard Editions

Today, database professionals must provide higher levels of data availability than ever before, as database systems are being widely used for critical applications. As service level agreements (SLAs) become stricter in terms of acceptable application downtime, administrators need tools that allow them to build robust, reliable, and recoverable systems. This includes not just tools needed for recovery when a disaster occurs, but also tools that allow continuity of service while necessary system maintenance is performed.

In response to these needs, Microsoft has implemented a comprehensive set of availability features in Microsoft SQL Server 2005 Enterprise Edition, which provides a highly reliable and available platform for enterprise-class relational database solutions. SQL Server 2005 Enterprise Edition addresses several availability issues, enabling administrators to perform operations online, to limit the scope of any disaster, utilize unlimited virtualization and most importantly, to limit or even prevent application downtime when a disaster occurs.

 

SQL Server 2005 Enterprise Edition Benefits

  • Allows fast storage querying large amounts of data (> 500 GB)

  • Scales as data grows

  • Supports high transactional online transaction processing (OLTP) applications

  • Includes “always on” technologies to ensure business continuity

    • Application remains online during operating system, hardware, and software upgrades.

    • Fast recovery from human errors. (Human error is identified as the number one cause of downtime.)

    • Minimum downtime during disaster recovery.

    • Zero downtime during maintenance operations.

  • Offers high performance business intelligence and data warehousing

  • Offers unlimited virtualization rights when the physical machine running the virtual environments is fully licensed

Common Usage Scenarios

SQL Server 2005 is available in a variety of editions to best match the demands of your applications. Here are a few exclusive usage scenarios that demand SQL Server 2005 Enterprise Edition:

  • Mission-critical OLTP applications that must scale and remain available

  • Server consolidation

  • Data warehousing

  • Complex analytics and data mining

  • Scale out and drill-through reporting

Choosing the right edition of SQL Server is crucial to the success of your business both today and in the future. Here is a summary of the differences between SQL Server 2005 Enterprise and Standard Edition features.

Scalability and Performance Comparison

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Number of CPUs

4

64

Memory

OS maximum

OS maximum

Multi-instance support

16

50

Dynamic address windows extensions (AWE) memory management

Available
Available

Table and index partitioning

Available

Database snapshots

Available

Scalable shared databases

Available

Indexed views

Available

Parallel index operations

Available

Parallel consistency checks (DBCC)

Available

Enhanced read-ahead and scan (super scan)

Available

High Availability "Always On" Comparison

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Failover clustering

Two-node only

Up to 8 nodes

Database mirroring 

Safety FULL only 

All modes

Database snapshots

/sqlserver/2005/en/us/PublishingImages/icon-table-full.gif

Fast recovery

Available

Online index operations

Available

Online page and file restore

Available

Parallel index operations

Available

Updateable distributed partitioned views

Available

Table and index partitioning

Available

Manageability Comparison

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Hot-add memory support

Available

Mirrored backup media

Available

Multi-server administration

Available

VIA protocol support

Available

Unlimited Virtualization

Available

Business Intelligence Comparison

 

Data Mining

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Parallelism for model processing

Available

Parallelism for model prediction

Available

Algorithm plug-in API

Available

Advanced configuration and tuning options for data mining algorithms

Available

 

Advanced Analytics

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Account intelligence

Available

Linked measures and dimensions

Available

Perspectives

Available

Semiadditive measures

Available

Writeback dimensions

Available

 

Scalability and Performance

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Proactive caching

Available

Auto parallel partition processing

Available

Partitioned cubes

Available

Distributed partitioned cubes

Available

 

Integration Services

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Data mining query transformation

Available

Data mining model training destination adapter

Available

Fuzzy Grouping transformation

Available

Fuzzy Lookup transformation

Available

Term Extraction transformation

Available

Term Lookup transformation

Available

Dimension processing destination adapter

Available

Partition processing destination adapter

Available

 

Reporting Services

Feature

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

Data-driven subscriptions

Available

Report scale-out deployment

Available

Infinite clickthrough in ad-hoc reports

Available