Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
CanadaDBA
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 |
|
biged123456
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...Matt |
|
|
sify
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. |
|
|
|
|
|