Results 1 to 8 of 8

Thread: Stupid question

  1. #1
    Join Date
    Aug 2003
    Location
    Liverpool, England
    Posts
    18

    Unanswered: Stupid question

    Probably a stupid question I know but:

    What is the difference between SQL Server 2000 Standard and Enterprise Edition?

    Cheers

    Hanley


  2. #2
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212

    Re: Stupid question

    Originally posted by Hanley
    Probably a stupid question I know but:

    What is the difference between SQL Server 2000 Standard and Enterprise Edition?

    Cheers

    Hanley


    Major diff I guess is the processors that are supported . Standard only support a max of 2 cpu.

    Urmm..a stupid comparison is Enterprise is way more expensive

    Enterprise editions generally give u more functions such as DPV, federated database processing. But to do that, you must be runing some very very big datawarehousing.

    Note: it doesn't really gives you load balancing functions .


    You can find out more here:

    http://www.mssqlcity.com/FAQ/General...0_editions.htm

    http://www.microsoft.com/sql/techinf...sKChooseEd.asp
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  3. #3
    Join Date
    Aug 2003
    Location
    Liverpool, England
    Posts
    18
    Patrick

    Thanks for your reply

    You've given me what I need to know

    Our server will have 4 processors - Enterprise it is then!!

    Cheers

    Hanley

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Patrick,

    I think you confused Standard with Personal. Standard will support up to 4 CPU's and 2G or RAM.

  5. #5
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    woops ! what was I thinking. Thanks for correcting me
    Hmm...I wonder if Hanley already purchase the software.
    Microsoft should thank me for their sales then.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    you're not working for M$ by any chance?

  7. #7
    Join Date
    Aug 2003
    Location
    Liverpool, England
    Posts
    18
    Guys

    Haven't purchased anything yet....thank god for e-mail notification

    Our production server will have 4 CPU's and 4GB of RAM - I'm assuming standard won't support that much RAM?

    Cheers

    Hanley

  8. #8
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The Standard Edition of SQL Server will support up to 2GB of memory. The O/S and any applications will probably be happy to eat the rest of the memory, though. Took a while to find, but this title in BOL sets out the limits:
    "Maximum Capacity Specifications"
    This article deals with what features are supported:
    "Features Supported by the Editions of SQL Server 2000"

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •