Difference Between SQL Server 2000 Enterprise and Standard Edition

  • Hi,

    I have mixed understanding reg Enterprise and Standard edition. Can someone please help me in pointing out the difference in bullet point or point me to a web site that talks about the difference between SQL Server 2000 Enterprise and Standard Editions esp in a cluster environment?  We are running Windows 2003 Enterprise. Is Enterprise required for cluster? What are the benefits of using Enterprise?

    Thanks in advance for any help.

    Thank you. 

  • Can't find the microsoft page immediately.

    a list of performance differences:

    http://www.sql-server-performance.com/q&a98.asp

    Enterprise edition is required for clustering, built-in logshipping, access to more cpu & memory.

  • Hi Jo,

    Thanks for your help. I read various postings and it says that "Enterprise Edition" is required for cluster. I am looking for Microsoft document stating this. Do you think there there is a microsoft page? I tried to google but it only has SQL Server 2005 and not 2000 material so far.

    Thanks. 

  • seems sql 2000 comparision got replaced with the 2005 version

    from the books online (2000)

    Features Supported by the Editions of SQL Server 2000

    This topic summarizes the features that the different editions of Microsoft® SQL Server™ 2000 support.

    Database Engine Features Supported by the Editions of SQL Server 2000

    This table shows the database engine features and the editions of SQL Server 2000 that support them.

    Database Engine FeatureEnterprise EditionStandard EditionPersonal EditionDeveloper EditionDesktop EngineSQL Server CEEnterprise Evaluation Edition
    Multiple Instance SupportSupportedSupportedSupportedSupportedSupportedN/ASupported
    Failover Clustering (up to four nodes)SupportedN/AN/ASupportedN/AN/ASupported
    Failover Support in SQL Server Enterprise ManagerSupportedN/AN/ASupportedN/AN/ASupported
    Log ShippingSupportedN/AN/ASupportedN/AN/ASupported
    Parallel DBCCSupportedN/AN/ASupportedN/AN/ASupported
    Parallel CREATE INDEXSupportedN/AN/ASupportedN/AN/ASupported
    Enhanced Read-ahead and ScanSupportedN/AN/ASupportedN/AN/ASupported
    Indexed ViewsSupportedN/AN/ASupportedN/AN/ASupported
    Federated Database ServerSupportedN/AN/ASupportedN/AN/ASupported
    System Area Network (SAN) SupportSupportedN/AN/ASupportedN/AN/ASupported
    Graphical DBA and Developer Utilities, WizardsSupportedSupportedSupportedSupportedN/AN/ASupported
    Graphical Utilities Support for Language SettingsSupportedN/AN/AN/AN/AN/AN/A
    Full-Text SearchSupportedSupportedSupported (except on Windows 98)SupportedN/AN/ASupported
    Replication Features Supported by the Editions of SQL Server 2000

    This table shows the replication features and the editions of SQL Server 2000 that support them.

    Replication Publisher Feature

    Enterprise Edition

    Standard Edition

    Personal Edition

    Developer Edition

    Desktop Engine

    SQL Server CE

    Enterprise Evaluation Edition
    Snapshot ReplicationSupportedSupportedSupportedSupportedSupportedN/ASupported
    Transactional ReplicationSupportedSupportedSubscriber onlySupportedSubscriber onlyN/ASupported
    Merge ReplicationSupportedSupportedSupportedSupportedSupportedAnonymous Subscriber onlySupported
    Immediate Updating SubscriptionsSupportedSupportedSupportedSupportedSupportedN/ASupported
    Queued Updating SubscribersSupportedSupportedSupportedSupportedSupportedN/ASupported
    Analysis Services Features Supported by the Editions of SQL Server 2000

    This table shows the Analysis Services features and the editions of SQL Server 2000 that support them.

    Analysis Services Feature

    Enterprise Edition

    Standard Edition

    Personal Edition

    Developer Edition

    Desktop Engine

    SQL Server CE

    Enterprise Evaluation Edition
    Analysis ServicesSupportedSupportedSupportedSupportedN/AN/ASupported
    User-defined OLAP PartitionsSupportedN/AN/ASupportedN/AN/ASupported
    Partition WizardSupportedN/AN/ASupportedN/AN/ASupported
    Linked OLAP CubesSupportedN/AN/ASupportedN/AN/ASupported
    ROLAP Dimension SupportSupportedN/AN/ASupportedN/AN/ASupported
    HTTP Internet SupportSupportedN/AN/ASupportedN/AN/ASupported
    Custom RollupsSupportedSupportedSupportedSupportedN/AN/ASupported
    Calculated CellsSupportedN/AN/ASupportedN/AN/ASupported
    Writeback to DimensionsSupportedN/AN/ASupportedN/AN/ASupported
    Very Large Dimension SupportSupportedN/AN/ASupportedN/AN/ASupported
    ActionsSupportedSupportedSupportedSupportedN/AN/ASupported
    Real-time OLAPSupportedN/AN/ASupportedN/AN/ASupported
    Distributed Partitioned CubesSupportedN/AN/ASupportedN/AN/ASupported
    Data MiningSupportedSupportedSupportedSupportedN/AN/ASupported
    Data Transformation and Decision Support Query Features Supported by the Editions of SQL Server 2000

    This table shows the data transformation and decision support query features and the editions of SQL Server 2000 that support them.

    Analysis Services Feature

    Enterprise Edition

    Standard Edition

    Personal Edition

    Developer Edition

    Desktop Engine

    SQL Server CE

    Enterprise Evaluation Edition
    Data Transformation ServicesSupportedSupportedSupportedSupportedDeployment onlyN/ASupported
    Integrated Data MiningSupportedSupportedSupportedSupportedN/AN/ASupported
    English QuerySupportedSupportedSupportedSupportedN/AN/ASupported
  • Here is the link for Previous Versions of Microsoft SQL Server:

    http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx

    -SQLBill

  • In order to have a 2-node cluster, Standard Edition of SQL 2005 will work.  But, you still need Enterprise Edition of the OS.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply