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?
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...
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.
Max Memory in Standard Edition
Posted - 10/07/2004 : 12:41:51
