July 27, 2004 at 9:10 am
I have been trying to track down exactly how much RAM standard edition can use. All of the threads and documentation I have been reading only talk about using AWE and the 3Gb switch in the boot.ini for the enterprise edition of SQL. Can anybody help me out or point me in the right direction?
Thanks!
July 27, 2004 at 9:25 am
2GB is the limit for Standard Edition. All the talk about AWE and the 3Gb switch applies to Enterprise Edition. Here is the official MS reference on the matter:
http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
July 27, 2004 at 9:42 am
Thanks! That is what I needed!
January 10, 2006 at 6:46 am
January 10, 2006 at 9:52 am
With the introduction of 2005 Standard Edition is no longer limited in the amount of RAM it can use
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
The page I referenced above seems to be removed, but if you look at Books Online under "Maximum Capacity Specifications" you can find the information.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply