SQL Server Performance

4 Procs and 4GB Memory - Standard or Enterprise?

Discussion in 'Performance Tuning for Hardware Configurations' started by DBADave, Oct 7, 2005.

  1. DBADave New Member

    I've read the documents regarding how many processors and how much memory each edition of SQL Server can handle. What I would like to know is will I see a performance gain with using SQL Server 2000 Enterprise Edition on a server with 4 processors and 4GB memory (2GB OS and 2GB SQL) vs. using SQL Server Standard Edition. Will EM better handle 4 procs than Standard?

    Thanks, Dave
  2. Luis Martin Moderator

    About memory up to 2GB and processor SE and EE are the same.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. DBADave New Member

    If that's the case the only reason I may wish to install EE is for log shipping. It's possible we may wish to pursure it for disaster recovery, but it's too early to tell. We currently use a product called Doubletake to copy server files from our primary site to our alternate data center, basically making a clone of production. Are there many problems associated with log shipping that would make it an unreliable DR option?

    Dave
  4. derrickleggett New Member

    Don't install for log shipping. Write your own scripts. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] IF you need more RAM, which is one of the biggest performance enhancers for SQL Server, you would want to upgrade. It seems odd to have a 4-processor server with only 4GB of RAM. But, that's me being weird I guess.<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
  5. DBADave New Member

    I agree the 4 processors appears to be a bit too much, however the database supports a third-party application that may not be written the most efficiently.

    Thanks, Dave

Share This Page