Yes, you are right - forgot about standard ed. limit of 4gb, here are
detailed specs:
Standard edition : Maximum of 4 CPU , Maximum of 4GB of RAM
Enterprise edition  : Maximum of 32GB RAM, 64GB RAM on 64bit, Maximum of 8
CPUs
Datacentre edition : Maximum of 64CPUs, 512GB RAM on 64bit edition
Web edition : Up to 2 CPUs and maximum of 2GB of RAM
  -----Original Message-----
  From: Matt Liotta [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, May 12, 2004 12:07 PM
  To: CF-Talk
  Subject: Re: The other shoe drops

  Just to be clear, the general rule on a Windows system is that you can
  access up to 2GB of RAM from a single process. Windows 2000/2003 can be
  configured to allow for a single process to access 3GB of RAM. If you
  have Windows 2000/2003 advanced or data center than a single process
  can access more than 3GB of RAM using non-standard system calls i.e. it
  has to be written specifically to do that. There is an overhead
  associated with all this that makes the effective amount of RAM
  available lower than the physical RAM. 64bit systems don't have this
  problem. I strongly recommend that you use an Opteron-based system for
  SQL Server if you want to use more than 4GB of RAM.

  -Matt
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to