4 Procs and 4GB Memory – Standard or Enterprise? | SQL Server Performance Forums

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
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.<br /><br />MeanOldDBA<br />[email protected]<br /><br />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