Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a SQL Server 2K5 installation on a Windows 2003 R2 server with eight cores and 16GB of RAM. While it's in our plan to upgrade it to 64-bit, for now we are on the 32-bit version.

Currently we have one instance set to use all available memory, but need to run two instances. Given that this is 32-bit and this would be two separate SQL2K5 instances, would I have two instances contending for the first 4GB, or would they both be able to address 4GB+?

Thanks! -Bob

share|improve this question

2 Answers 2

up vote 0 down vote accepted

You don't need SQL 2005 Enterprise Edition for using AWE - Standard will work fine. See this TechNet link.

share|improve this answer
    
You are right of course Paul. My fault, i went on this page but i stop reading after the "enterprise" word, like an idiot –  Mathieu Chateau Feb 3 '10 at 18:50

They can both use more than 4GB. But:

  • You need PAE activated (/PAE in boot.ini)
  • You need Windows enterprise at least
  • You need enterprise SQL Server Version
  • all memory > 4GB will be used only as cache. Can't use to store objects & co

You should go 64 bit as soon as possible

share|improve this answer
    
Thanks for the quick reply! We're on SQL2K5 standard, Windows 2003 Enterprise. What effect does being on SQL2K5 standard have on this problem? –  Bob Palmer Feb 3 '10 at 16:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.