Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Max Memory in Standard Edition

Author  Topic 


583 Posts

Posted - 2004-10-07 : 12:41:51
I was looking at the difference between Standard and Enterprise Editions. One of the Enterprise edition feature was “Ability to support more RAM (up to 64GB instead of only 2GB)”.

I have Standard Edition on a server with 3.5GB and EM shows Maximum of 3584MB under Memory tab in SQL Server Properties.

I am confused that Standard Edition is using only 2GB or more on my server. Would you update me?

Canada DBA

Starting Member

4 Posts

Posted - 2004-10-07 : 13:54:22
Standard SQL will not use more than 2G of memory (actually more like ~1.7G). EM may show the higher values, but it won't get there in standard. You can verify this in performance monitor. Just poor GUI design I suppose...

Go to Top of Page

Starting Member

18 Posts

Posted - 2004-10-12 : 02:54:56
SQL Server Standard Edition will only use 2GB of the RAM on any o.s. Enterprise edition can use upto 64GB on windows datacenter provided AWE is turned on.
Go to Top of Page

- Advertisement -