SQL Server Performance Forum – Threads Archive

4 Procs and 4GB Memory – Standard or Enterprise?

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

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.

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

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. MeanOldDBA [email protected] When life gives you a lemon, fire the DBA.

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

]]>