January 19, 2005 at 8:23 am
I know that SQL Server Enterprise Edition can use more than 2 GB of memory using the AWE support.
However, if a server has more than 2 GB and SQL Server Standard is instaled, is there any way that SQL Server will use more than 2GB? I think not, but if anyone knows otherwise, please share.
Thanks,
Gabriela
January 19, 2005 at 8:26 am
I think 2GB is it. Although, with SQL Standard licensed per processor, maybe a machine with 4GB memory, and 2 instances of SQL standard could each use their own 2GB??
I'm not sure - never tried it.
Ryan
January 19, 2005 at 8:48 am
See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 19, 2005 at 8:55 am
You can also research this in BOL under Index tab:
Editions of SQL Server and then select Maximum Capacity Specifications under topics found
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 19, 2005 at 9:17 am
Yeah, I think that BOL is pretty clear.
Thanks all for your inputs.
Gabriela
January 20, 2005 at 1:49 am
You can add the /3GB switch to the boot.ini file which I believe allows SS200 Standad edition to use 3GB, athough this server should be a dedicated SQL server machine.
Neil.
January 20, 2005 at 2:39 am
Can you verify this?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 20, 2005 at 3:11 am
Nope I've not tested this, but I remember reading this on a forum somewhere some time ago, but cannot find it now maybe my memory is playing tricks on me (pun not intented). All docs now say need Enterprise to make use of >2GB RAM
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply